CREATE database if NOT EXISTS `eshop_address` default character set utf8 collate utf8_general_ci;
use `eshop_address`;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增列',
  `code` varchar(40) NOT NULL COMMENT '区代码',
  `city_code` varchar(40) DEFAULT NULL COMMENT '父级市代码',
  `name` varchar(40) NOT NULL COMMENT '市名称',
  `short_name` varchar(20) NOT NULL COMMENT '简称',
  `lng` varchar(20) DEFAULT NULL COMMENT '经度',
  `lat` varchar(20) DEFAULT NULL COMMENT '纬度',
  `sort` int(6) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_code` (`code`) USING BTREE,
  KEY `idx_name` (`name`) USING BTREE,
  KEY `idx_city_code` (`city_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3679 DEFAULT CHARSET=utf8 COMMENT='地区设置';

-- ----------------------------
-- Records of area
-- ----------------------------
BEGIN;
INSERT INTO `area` VALUES (1, '110101', '110100', '东城区', '东城', '116.418755', '39.917545', 3);
INSERT INTO `area` VALUES (2, '110102', '110100', '西城区', '西城', '116.366791', '39.91531', 15);
INSERT INTO `area` VALUES (3, '110105', '110100', '朝阳区', '朝阳', '116.486412', '39.92149', 2);
INSERT INTO `area` VALUES (4, '110106', '110100', '丰台区', '丰台', '116.286964', '39.863644', 6);
INSERT INTO `area` VALUES (5, '110107', '110100', '石景山区', '石景山', '116.195442', '39.9146', 12);
INSERT INTO `area` VALUES (6, '110108', '110100', '海淀区', '海淀', '116.310318', '39.956074', 7);
INSERT INTO `area` VALUES (7, '110109', '110100', '门头沟区', '门头沟', '116.105377', '39.937183', 9);
INSERT INTO `area` VALUES (8, '110111', '110100', '房山区', '房山', '116.13916', '39.735535', 5);
INSERT INTO `area` VALUES (9, '110112', '110100', '通州区', '通州', '116.6586', '39.902485', 14);
INSERT INTO `area` VALUES (10, '110113', '110100', '顺义区', '顺义', '116.653526', '40.128937', 13);
INSERT INTO `area` VALUES (11, '110114', '110100', '昌平区', '昌平', '116.235909', '40.218086', 1);
INSERT INTO `area` VALUES (12, '110115', '110100', '大兴区', '大兴', '116.338036', '39.728909', 4);
INSERT INTO `area` VALUES (13, '110116', '110100', '怀柔区', '怀柔', '116.637123', '40.324272', 8);
INSERT INTO `area` VALUES (14, '110117', '110100', '平谷区', '平谷', '117.112335', '40.144783', 11);
INSERT INTO `area` VALUES (15, '110228', '110100', '密云县', '密云', '116.843353', '40.377361', 10);
INSERT INTO `area` VALUES (16, '110229', '110100', '延庆县', '延庆', '115.985008', '40.465324', 16);
INSERT INTO `area` VALUES (17, '120101', '120100', '和平区', '和平', '117.195908', '39.118328', 7);
INSERT INTO `area` VALUES (18, '120102', '120100', '河东区', '河东', '117.22657', '39.122124', 6);
INSERT INTO `area` VALUES (19, '120103', '120100', '河西区', '河西', '117.217537', '39.101898', 8);
INSERT INTO `area` VALUES (20, '120104', '120100', '南开区', '南开', '117.164146', '39.120476', 13);
INSERT INTO `area` VALUES (21, '120105', '120100', '河北区', '河北', '117.201569', '39.156631', 5);
INSERT INTO `area` VALUES (22, '120106', '120100', '红桥区', '红桥', '117.1633', '39.175068', 9);
INSERT INTO `area` VALUES (23, '120110', '120100', '东丽区', '东丽', '117.313965', '39.087765', 4);
INSERT INTO `area` VALUES (24, '120111', '120100', '西青区', '西青', '117.012245', '39.139446', 16);
INSERT INTO `area` VALUES (25, '120112', '120100', '津南区', '津南', '117.382545', '38.989578', 11);
INSERT INTO `area` VALUES (26, '120113', '120100', '北辰区', '北辰', '117.134819', '39.225555', 2);
INSERT INTO `area` VALUES (27, '120114', '120100', '武清区', '武清', '117.057961', '39.376926', 15);
INSERT INTO `area` VALUES (28, '120115', '120100', '宝坻区', '宝坻', '117.30809', '39.716965', 1);
INSERT INTO `area` VALUES (29, '120116', '120100', '滨海新区', '滨海', '117.654175', '39.032845', 3);
INSERT INTO `area` VALUES (30, '120221', '120100', '宁河县', '宁河', '117.828278', '39.328884', 14);
INSERT INTO `area` VALUES (31, '120223', '120100', '静海县', '静海', '116.925301', '38.935673', 10);
INSERT INTO `area` VALUES (32, '120225', '120100', '蓟县', '蓟县', '117.407448', '40.045341', 12);
INSERT INTO `area` VALUES (718, '310101', '310100', '黄浦区', '黄浦', '121.490318', '31.222771', 7);
INSERT INTO `area` VALUES (719, '310104', '310100', '徐汇区', '徐汇', '121.437523', '31.179974', 15);
INSERT INTO `area` VALUES (720, '310105', '310100', '长宁区', '长宁', '121.422203', '31.218122', 2);
INSERT INTO `area` VALUES (721, '310106', '310100', '静安区', '静安', '121.448227', '31.229004', 9);
INSERT INTO `area` VALUES (722, '310107', '310100', '普陀区', '普陀', '121.392502', '31.241701', 12);
INSERT INTO `area` VALUES (723, '310108', '310100', '闸北区', '闸北', '121.465691', '31.25318', 17);
INSERT INTO `area` VALUES (724, '310109', '310100', '虹口区', '虹口', '121.491829', '31.260969', 6);
INSERT INTO `area` VALUES (725, '310110', '310100', '杨浦区', '杨浦', '121.522797', '31.270756', 16);
INSERT INTO `area` VALUES (726, '310112', '310100', '闵行区', '闵行', '121.375969', '31.111658', 11);
INSERT INTO `area` VALUES (727, '310113', '310100', '宝山区', '宝山', '121.489937', '31.398895', 1);
INSERT INTO `area` VALUES (728, '310114', '310100', '嘉定区', '嘉定', '121.250336', '31.383524', 8);
INSERT INTO `area` VALUES (729, '310115', '310100', '浦东新区', '浦东', '121.567703', '31.245943', 4);
INSERT INTO `area` VALUES (730, '310116', '310100', '金山区', '金山', '121.330734', '30.724697', 10);
INSERT INTO `area` VALUES (731, '310117', '310100', '松江区', '松江', '121.223541', '31.03047', 14);
INSERT INTO `area` VALUES (732, '310118', '310100', '青浦区', '青浦', '121.113022', '31.151209', 13);
INSERT INTO `area` VALUES (733, '310120', '310100', '奉贤区', '奉贤', '121.458473', '30.912346', 5);
INSERT INTO `area` VALUES (734, '310230', '310100', '崇明县', '崇明', '121.397514', '31.626945', 3);
INSERT INTO `area` VALUES (1975, '500101', '500100', '万州区', '万州', '108.380249', '30.807808', 28);
INSERT INTO `area` VALUES (1976, '500102', '500100', '涪陵区', '涪陵', '107.394905', '29.703651', 11);
INSERT INTO `area` VALUES (1977, '500103', '500100', '渝中区', '渝中', '106.562881', '29.556742', 37);
INSERT INTO `area` VALUES (1978, '500104', '500100', '大渡口区', '大渡口', '106.48613', '29.481003', 6);
INSERT INTO `area` VALUES (1979, '500105', '500100', '江北区', '江北', '106.532845', '29.575352', 13);
INSERT INTO `area` VALUES (1980, '500106', '500100', '沙坪坝区', '沙坪坝', '106.454201', '29.541224', 24);
INSERT INTO `area` VALUES (1981, '500107', '500100', '九龙坡区', '九龙坡', '106.480988', '29.523493', 15);
INSERT INTO `area` VALUES (1982, '500108', '500100', '南岸区', '南岸', '106.560814', '29.523993', 18);
INSERT INTO `area` VALUES (1983, '500109', '500100', '北碚区', '北碚', '106.437866', '29.82543', 2);
INSERT INTO `area` VALUES (1984, '500112', '500100', '渝北区', '渝北', '106.512848', '29.601452', 35);
INSERT INTO `area` VALUES (1985, '500113', '500100', '巴南区', '巴南', '106.519424', '29.38192', 1);
INSERT INTO `area` VALUES (1986, '500114', '500100', '黔江区', '黔江', '108.782578', '29.527548', 21);
INSERT INTO `area` VALUES (1987, '500115', '500100', '长寿区', '长寿', '107.074852', '29.833672', 4);
INSERT INTO `area` VALUES (1988, '500222', '500100', '綦江区', '綦江', '106.651421', '29.028091', 22);
INSERT INTO `area` VALUES (1989, '500223', '500100', '潼南县', '潼南', '105.84182', '30.189554', 27);
INSERT INTO `area` VALUES (1990, '500224', '500100', '铜梁县', '铜梁', '106.054947', '29.839945', 26);
INSERT INTO `area` VALUES (1991, '500225', '500100', '大足区', '大足', '105.715317', '29.700499', 7);
INSERT INTO `area` VALUES (1992, '500226', '500100', '荣昌县', '荣昌', '105.594063', '29.403627', 23);
INSERT INTO `area` VALUES (1993, '500227', '500100', '璧山县', '璧山', '106.231125', '29.59358', 3);
INSERT INTO `area` VALUES (1994, '500228', '500100', '梁平县', '梁平', '107.800034', '30.672169', 17);
INSERT INTO `area` VALUES (1995, '500229', '500100', '城口县', '城口', '108.664902', '31.946293', 5);
INSERT INTO `area` VALUES (1996, '500230', '500100', '丰都县', '丰都', '107.732483', '29.866425', 9);
INSERT INTO `area` VALUES (1997, '500231', '500100', '垫江县', '垫江', '107.348694', '30.330011', 8);
INSERT INTO `area` VALUES (1998, '500232', '500100', '武隆县', '武隆', '107.756554', '29.323759', 29);
INSERT INTO `area` VALUES (1999, '500233', '500100', '忠县', '忠县', '108.037521', '30.291536', 38);
INSERT INTO `area` VALUES (2000, '500234', '500100', '开县', '开县', '108.413315', '31.167734', 16);
INSERT INTO `area` VALUES (2001, '500235', '500100', '云阳县', '云阳', '108.697701', '30.930529', 36);
INSERT INTO `area` VALUES (2002, '500236', '500100', '奉节县', '奉节', '109.465775', '31.019966', 10);
INSERT INTO `area` VALUES (2003, '500237', '500100', '巫山县', '巫山', '109.878929', '31.074842', 30);
INSERT INTO `area` VALUES (2004, '500238', '500100', '巫溪县', '巫溪', '109.628914', '31.396601', 31);
INSERT INTO `area` VALUES (2005, '500240', '500100', '石柱土家族自治县', '石柱', '108.11245', '29.998529', 25);
INSERT INTO `area` VALUES (2006, '500241', '500100', '秀山土家族苗族自治县', '秀山', '108.99604', '28.444773', 32);
INSERT INTO `area` VALUES (2007, '500242', '500100', '酉阳土家族苗族自治县', '酉阳', '108.767204', '28.839828', 34);
INSERT INTO `area` VALUES (2008, '500243', '500100', '彭水苗族土家族自治县', '彭水', '108.16655', '29.293856', 20);
INSERT INTO `area` VALUES (2009, '500381', '500100', '江津区', '江津', '106.253159', '29.283386', 14);
INSERT INTO `area` VALUES (2010, '500382', '500100', '合川区', '合川', '106.265556', '29.990993', 12);
INSERT INTO `area` VALUES (2011, '500383', '500100', '永川区', '永川', '105.894714', '29.348747', 33);
INSERT INTO `area` VALUES (2012, '500384', '500100', '南川区', '南川', '107.098152', '29.156647', 19);
COMMIT;

-- ----------------------------
-- Table structure for city
-- ----------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增列',
  `code` varchar(40) NOT NULL COMMENT '市代码',
  `name` varchar(40) NOT NULL COMMENT '市名称',
  `short_code` varchar(20) NOT NULL COMMENT '简称',
  `province_code` varchar(40) DEFAULT NULL COMMENT '省代码',
  `lng` varchar(20) DEFAULT NULL COMMENT '经度',
  `lat` varchar(20) DEFAULT NULL COMMENT '纬度',
  `sort` int(6) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_code` (`code`) USING BTREE,
  KEY `idx_name` (`name`) USING BTREE,
  KEY `idx_province_code` (`province_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=391 DEFAULT CHARSET=utf8 COMMENT='城市设置';

-- ----------------------------
-- Records of city
-- ----------------------------
BEGIN;
INSERT INTO `city` VALUES (1, '110100', '北京市', '北京', '110000', '116.405289', '39.904987', 1);
INSERT INTO `city` VALUES (2, '120100', '天津市', '天津', '120000', '117.190186', '39.125595', 1);
INSERT INTO `city` VALUES (73, '310100', '上海市', '上海', '310000', '121.472641', '31.231707', 1);
INSERT INTO `city` VALUES (134, '370100', '济南市', '济南', '370000', '117.000923', '36.675808', 5);
INSERT INTO `city` VALUES (135, '370200', '青岛市', '青岛', '370000', '120.355171', '36.082981', 10);
INSERT INTO `city` VALUES (136, '370300', '淄博市', '淄博', '370000', '118.047646', '36.814938', 17);
INSERT INTO `city` VALUES (137, '370400', '枣庄市', '枣庄', '370000', '117.557961', '34.856422', 16);
INSERT INTO `city` VALUES (138, '370500', '东营市', '东营', '370000', '118.664711', '37.434563', 3);
INSERT INTO `city` VALUES (139, '370600', '烟台市', '烟台', '370000', '121.39138', '37.539295', 15);
INSERT INTO `city` VALUES (140, '370700', '潍坊市', '潍坊', '370000', '119.107079', '36.709251', 13);
INSERT INTO `city` VALUES (141, '370800', '济宁市', '济宁', '370000', '116.587242', '35.415394', 6);
INSERT INTO `city` VALUES (142, '370900', '泰安市', '泰安', '370000', '117.129066', '36.194969', 12);
INSERT INTO `city` VALUES (143, '371000', '威海市', '威海', '370000', '122.116394', '37.509689', 14);
INSERT INTO `city` VALUES (144, '371100', '日照市', '日照', '370000', '119.461205', '35.428589', 11);
INSERT INTO `city` VALUES (145, '371200', '莱芜市', '莱芜', '370000', '117.677734', '36.214397', 7);
INSERT INTO `city` VALUES (146, '371300', '临沂市', '临沂', '370000', '118.326447', '35.065281', 9);
INSERT INTO `city` VALUES (147, '371400', '德州市', '德州', '370000', '116.307426', '37.453968', 2);
INSERT INTO `city` VALUES (148, '371500', '聊城市', '聊城', '370000', '115.98037', '36.456013', 8);
INSERT INTO `city` VALUES (149, '371600', '滨州市', '滨州', '370000', '118.016975', '37.383541', 1);
INSERT INTO `city` VALUES (150, '371700', '菏泽市', '菏泽', '370000', '115.469383', '35.246532', 4);
INSERT INTO `city` VALUES (255, '500100', '重庆市', '重庆', '500000', '106.504959', '29.533155', 1);
COMMIT;

-- ----------------------------
-- Table structure for province
-- ----------------------------
DROP TABLE IF EXISTS `province`;
CREATE TABLE `province` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增列',
  `code` varchar(40) NOT NULL COMMENT '省份代码',
  `name` varchar(50) NOT NULL COMMENT '省份名称',
  `short_name` varchar(20) NOT NULL COMMENT '简称',
  `lng` varchar(20) DEFAULT NULL COMMENT '经度',
  `lat` varchar(20) DEFAULT NULL COMMENT '纬度',
  `sort` int(6) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_code` (`code`) USING BTREE,
  KEY `idx_name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COMMENT='省份设置';

-- ----------------------------
-- Records of province
-- ----------------------------
BEGIN;
INSERT INTO `province` VALUES (1, '110000', '北京', '北京', '116.405289', '39.904987', 1);
INSERT INTO `province` VALUES (2, '120000', '天津', '天津', '117.190186', '39.125595', 2);
INSERT INTO `province` VALUES (9, '310000', '上海', '上海', '121.472641', '31.231707', 9);
INSERT INTO `province` VALUES (22, '500000', '重庆', '重庆', '106.504959', '29.533155', 22);
COMMIT;

-- ----------------------------
-- Table structure for street
-- ----------------------------
DROP TABLE IF EXISTS `street`;
CREATE TABLE `street` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增列',
  `code` varchar(40) NOT NULL COMMENT '街道代码',
  `area_code` varchar(40) DEFAULT NULL COMMENT '父级区代码',
  `name` varchar(50) NOT NULL COMMENT '街道名称',
  `short_name` varchar(30) NOT NULL COMMENT '简称',
  `lng` varchar(20) DEFAULT NULL COMMENT '经度',
  `lat` varchar(20) DEFAULT NULL COMMENT '纬度',
  `sort` int(6) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_code` (`code`) USING BTREE,
  KEY `idx_name` (`name`) USING BTREE,
  KEY `idx_area_code` (`area_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=42361 DEFAULT CHARSET=utf8 COMMENT='街道设置';

-- ----------------------------
-- Records of street
-- ----------------------------
BEGIN;
INSERT INTO `street` VALUES (1, '110101001', '110101', '东华门街道', '东华门街道', '116.409607', '39.917973', 5);
INSERT INTO `street` VALUES (2, '110101002', '110101', '景山街道', '景山街道', '116.410049', '39.92688', 12);
INSERT INTO `street` VALUES (3, '110101003', '110101', '交道口街道', '交道口街道', '116.405479', '39.9366', 11);
INSERT INTO `street` VALUES (4, '110101004', '110101', '安定门街道', '安定门街道', '116.403862', '39.944294', 1);
INSERT INTO `street` VALUES (5, '110101005', '110101', '北新桥街道', '北新桥街道', '116.424095', '39.942024', 2);
INSERT INTO `street` VALUES (6, '110101006', '110101', '东四街道', '东四街道', '116.423729', '39.93026', 7);
INSERT INTO `street` VALUES (7, '110101007', '110101', '朝阳门街道', '朝阳门街道', '116.428055', '39.9188', 3);
INSERT INTO `street` VALUES (8, '110101008', '110101', '建国门街道', '建国门街道', '116.426224', '39.910351', 10);
INSERT INTO `street` VALUES (9, '110101009', '110101', '东直门街道', '东直门街道', '116.440498', '39.934071', 8);
INSERT INTO `street` VALUES (10, '110101010', '110101', '和平里街道', '和平里街道', '116.42347', '39.954552', 9);
INSERT INTO `street` VALUES (11, '110101011', '110101', '前门街道', '前门街道', '116.40834', '39.898033', 14);
INSERT INTO `street` VALUES (12, '110101012', '110101', '崇文门外街道', '崇文门外街道', '116.412598', '39.89743', 4);
INSERT INTO `street` VALUES (13, '110101013', '110101', '东花市街道', '东花市街道', '116.429489', '39.899067', 6);
INSERT INTO `street` VALUES (14, '110101014', '110101', '龙潭街道', '龙潭街道', '116.436722', '39.887169', 13);
INSERT INTO `street` VALUES (15, '110101015', '110101', '体育馆路街道', '体育馆路街道', '116.418755', '39.917545', 16);
INSERT INTO `street` VALUES (16, '110101016', '110101', '天坛街道', '天坛街道', '116.40004', '39.889736', 15);
INSERT INTO `street` VALUES (17, '110101017', '110101', '永定门外街道', '永定门外街道', '116.401382', '39.866001', 17);
INSERT INTO `street` VALUES (18, '110102001', '110102', '西长安街街道', '西长安街街道', '116.366791', '39.91531', 13);
INSERT INTO `street` VALUES (19, '110102003', '110102', '新街口街道', '新街口街道', '116.370972', '39.943054', 12);
INSERT INTO `street` VALUES (20, '110102007', '110102', '月坛街道', '月坛街道', '116.344398', '39.915092', 14);
INSERT INTO `street` VALUES (21, '110102009', '110102', '展览路街道', '展览路街道', '116.366791', '39.91531', 15);
INSERT INTO `street` VALUES (22, '110102010', '110102', '德胜街道', '德胜街道', '116.366791', '39.91531', 4);
INSERT INTO `street` VALUES (23, '110102011', '110102', '金融街街道', '金融街街道', '116.366791', '39.91531', 7);
INSERT INTO `street` VALUES (24, '110102012', '110102', '什刹海街道', '什刹海街道', '116.366791', '39.91531', 9);
INSERT INTO `street` VALUES (25, '110102013', '110102', '大栅栏街道', '大栅栏街道', '116.39399', '39.893547', 3);
INSERT INTO `street` VALUES (26, '110102014', '110102', '天桥街道', '天桥街道', '116.386925', '39.884876', 11);
INSERT INTO `street` VALUES (27, '110102015', '110102', '椿树街道', '椿树街道', '116.375763', '39.899055', 2);
INSERT INTO `street` VALUES (28, '110102016', '110102', '陶然亭街道', '陶然亭街道', '116.380646', '39.883484', 10);
INSERT INTO `street` VALUES (29, '110102017', '110102', '广安门内街道', '广安门内街道', '116.362999', '39.889526', 5);
INSERT INTO `street` VALUES (30, '110102018', '110102', '牛街街道', '牛街街道', '116.366791', '39.91531', 8);
INSERT INTO `street` VALUES (31, '110102019', '110102', '白纸坊街道', '白纸坊街道', '116.363579', '39.877087', 1);
INSERT INTO `street` VALUES (32, '110102020', '110102', '广安门外街道', '广安门外街道', '116.340057', '39.890453', 6);
INSERT INTO `street` VALUES (33, '110105001', '110105', '建外街道', '建外街道', '116.486412', '39.92149', 18);
INSERT INTO `street` VALUES (34, '110105002', '110105', '朝外街道', '朝外街道', '116.486412', '39.92149', 5);
INSERT INTO `street` VALUES (35, '110105003', '110105', '呼家楼街道', '呼家楼街道', '116.464325', '39.920929', 16);
INSERT INTO `street` VALUES (36, '110105004', '110105', '三里屯街道', '三里屯街道', '116.447914', '39.937122', 29);
INSERT INTO `street` VALUES (37, '110105005', '110105', '左家庄街道', '左家庄街道', '116.451515', '39.949432', 43);
INSERT INTO `street` VALUES (38, '110105006', '110105', '香河园街道', '香河园街道', '116.43911', '39.961151', 39);
INSERT INTO `street` VALUES (39, '110105007', '110105', '和平街街道', '和平街街道', '116.486412', '39.92149', 15);
INSERT INTO `street` VALUES (40, '110105008', '110105', '安贞街道', '安贞街道', '116.401085', '39.96804', 1);
INSERT INTO `street` VALUES (41, '110105009', '110105', '亚运村街道', '亚运村街道', '116.409248', '39.984192', 42);
INSERT INTO `street` VALUES (42, '110105010', '110105', '小关街道', '小关街道', '116.412659', '39.977505', 40);
INSERT INTO `street` VALUES (43, '110105011', '110105', '酒仙桥街道', '酒仙桥街道', '116.490242', '39.964268', 21);
INSERT INTO `street` VALUES (44, '110105012', '110105', '麦子店街道', '麦子店街道', '116.472198', '39.946911', 24);
INSERT INTO `street` VALUES (45, '110105013', '110105', '团结湖街道', '团结湖街道', '116.462578', '39.931461', 35);
INSERT INTO `street` VALUES (46, '110105014', '110105', '六里屯街道', '六里屯街道', '116.479851', '39.928219', 23);
INSERT INTO `street` VALUES (47, '110105015', '110105', '八里庄街道', '八里庄街道', '116.478851', '39.914959', 3);
INSERT INTO `street` VALUES (48, '110105016', '110105', '双井街道', '双井街道', '116.449379', '39.887966', 32);
INSERT INTO `street` VALUES (49, '110105017', '110105', '劲松街道', '劲松街道', '116.460236', '39.88493', 19);
INSERT INTO `street` VALUES (50, '110105018', '110105', '潘家园街道', '潘家园街道', '116.451332', '39.874855', 26);
INSERT INTO `street` VALUES (51, '110105019', '110105', '垡头街道', '垡头街道', '116.51088', '39.867611', 11);
INSERT INTO `street` VALUES (52, '110105021', '110105', '南磨房', '南磨房', '116.478004', '39.883575', 25);
INSERT INTO `street` VALUES (53, '110105022', '110105', '高碑店', '高碑店', '116.533867', '39.904636', 12);
INSERT INTO `street` VALUES (54, '110105023', '110105', '将台', '将台', '116.488976', '39.96888', 17);
INSERT INTO `street` VALUES (55, '110105024', '110105', '太阳宫', '太阳宫', '116.44297', '39.973053', 34);
INSERT INTO `street` VALUES (56, '110105025', '110105', '大屯街道', '大屯街道', '116.486412', '39.92149', 7);
INSERT INTO `street` VALUES (57, '110105026', '110105', '望京街道', '望京街道', '116.46936', '39.992771', 36);
INSERT INTO `street` VALUES (58, '110105027', '110105', '小红门', '小红门', '116.448891', '39.813721', 41);
INSERT INTO `street` VALUES (59, '110105028', '110105', '十八里店', '十八里店', '116.482971', '39.851437', 30);
INSERT INTO `street` VALUES (60, '110105029', '110105', '平房', '平房', '116.486412', '39.92149', 27);
INSERT INTO `street` VALUES (61, '110105030', '110105', '东风', '东风', '116.486412', '39.92149', 9);
INSERT INTO `street` VALUES (62, '110105031', '110105', '奥运村街道', '奥运村街道', '116.486412', '39.92149', 2);
INSERT INTO `street` VALUES (63, '110105032', '110105', '来广营', '来广营', '116.433525', '40.032036', 22);
INSERT INTO `street` VALUES (64, '110105033', '110105', '常营', '常营', '116.586838', '39.93235', 4);
INSERT INTO `street` VALUES (65, '110105034', '110105', '三间房', '三间房', '116.580421', '39.907997', 28);
INSERT INTO `street` VALUES (66, '110105035', '110105', '管庄', '管庄', '116.593246', '39.91074', 13);
INSERT INTO `street` VALUES (67, '110105036', '110105', '金盏', '金盏', '116.568649', '40.003006', 20);
INSERT INTO `street` VALUES (68, '110105037', '110105', '孙河', '孙河', '116.52356', '40.041115', 33);
INSERT INTO `street` VALUES (69, '110105038', '110105', '崔各庄', '崔各庄', '116.515221', '40.000652', 6);
INSERT INTO `street` VALUES (70, '110105039', '110105', '东坝', '东坝', '116.546272', '39.968742', 8);
INSERT INTO `street` VALUES (71, '110105040', '110105', '黑庄户', '黑庄户', '116.596657', '39.853325', 14);
INSERT INTO `street` VALUES (72, '110105041', '110105', '豆各庄', '豆各庄', '116.572556', '39.873047', 10);
INSERT INTO `street` VALUES (73, '110105042', '110105', '王四营', '王四营', '116.530945', '39.875202', 38);
INSERT INTO `street` VALUES (74, '110105043', '110105', '首都机场街道', '首都机场街道', '116.591217', '40.048229', 31);
INSERT INTO `street` VALUES (75, '110105501', '110105', '望京开发街道', '望京开发街道', '116.486412', '39.92149', 37);
INSERT INTO `street` VALUES (76, '110106001', '110106', '右安门街道', '右安门街道', '116.370247', '39.861198', 18);
INSERT INTO `street` VALUES (77, '110106002', '110106', '太平桥街道', '太平桥街道', '116.320007', '39.8834', 13);
INSERT INTO `street` VALUES (78, '110106003', '110106', '西罗园街道', '西罗园街道', '116.384293', '39.86441', 16);
INSERT INTO `street` VALUES (79, '110106004', '110106', '大红门街道', '大红门街道', '116.407379', '39.838314', 1);
INSERT INTO `street` VALUES (80, '110106005', '110106', '南苑街道', '南苑街道', '116.393547', '39.805305', 12);
INSERT INTO `street` VALUES (81, '110106006', '110106', '东高地街道', '东高地街道', '116.420662', '39.807209', 2);
INSERT INTO `street` VALUES (82, '110106007', '110106', '东铁匠营街道', '东铁匠营街道', '116.417114', '39.859398', 3);
INSERT INTO `street` VALUES (83, '110106008', '110106', '卢沟桥街道', '卢沟桥街道', '116.281425', '39.870892', 9);
INSERT INTO `street` VALUES (84, '110106009', '110106', '丰台街道', '丰台街道', '116.28685', '39.848854', 5);
INSERT INTO `street` VALUES (85, '110106010', '110106', '新村街道', '新村街道', '116.308426', '39.839706', 17);
INSERT INTO `street` VALUES (86, '110106011', '110106', '长辛店街道', '长辛店街道', '116.210548', '39.826126', 20);
INSERT INTO `street` VALUES (87, '110106012', '110106', '云岗街道', '云岗街道', '116.16291', '39.81176', 19);
INSERT INTO `street` VALUES (88, '110106013', '110106', '方庄', '方庄', '116.444229', '39.860241', 4);
INSERT INTO `street` VALUES (89, '110106014', '110106', '宛平城', '宛平城', '116.286964', '39.863644', 15);
INSERT INTO `street` VALUES (90, '110106015', '110106', '马家堡街道', '马家堡街道', '116.36795', '39.847233', 10);
INSERT INTO `street` VALUES (91, '110106016', '110106', '和义街道', '和义街道', '116.396111', '39.812717', 6);
INSERT INTO `street` VALUES (92, '110106017', '110106', '卢沟桥', '卢沟桥', '116.295036', '39.8671', 8);
INSERT INTO `street` VALUES (93, '110106018', '110106', '花乡', '花乡', '116.330498', '39.832306', 7);
INSERT INTO `street` VALUES (94, '110106019', '110106', '南苑', '南苑', '116.286964', '39.863644', 11);
INSERT INTO `street` VALUES (95, '110106100', '110106', '长辛店镇', '长辛店镇', '116.209229', '39.841064', 21);
INSERT INTO `street` VALUES (96, '110106101', '110106', '王佐镇', '王佐镇', '116.156181', '39.801369', 14);
INSERT INTO `street` VALUES (97, '110107001', '110107', '八宝山街道', '八宝山街道', '116.231972', '39.898903', 1);
INSERT INTO `street` VALUES (98, '110107002', '110107', '老山街道', '老山街道', '116.222443', '39.91058', 6);
INSERT INTO `street` VALUES (99, '110107003', '110107', '八角街道', '八角街道', '116.195648', '39.916122', 2);
INSERT INTO `street` VALUES (100, '110107004', '110107', '古城街道', '古城街道', '116.190033', '39.914886', 4);
INSERT INTO `street` VALUES (101, '110107005', '110107', '苹果园街道', '苹果园街道', '116.185539', '39.928898', 8);
INSERT INTO `street` VALUES (102, '110107006', '110107', '金顶街街道', '金顶街街道', '116.195442', '39.9146', 5);
INSERT INTO `street` VALUES (103, '110107009', '110107', '广宁街道', '广宁街道', '116.195442', '39.9146', 3);
INSERT INTO `street` VALUES (104, '110107010', '110107', '五里坨街道', '五里坨街道', '116.125771', '39.956409', 9);
INSERT INTO `street` VALUES (105, '110107011', '110107', '鲁谷街道', '鲁谷街道', '116.195442', '39.9146', 7);
INSERT INTO `street` VALUES (106, '110108001', '110108', '万寿路街道', '万寿路街道', '116.310318', '39.956074', 19);
INSERT INTO `street` VALUES (107, '110108002', '110108', '永定路街道', '永定路街道', '116.310318', '39.956074', 27);
INSERT INTO `street` VALUES (108, '110108003', '110108', '羊坊店街道', '羊坊店街道', '116.304726', '39.911819', 25);
INSERT INTO `street` VALUES (109, '110108004', '110108', '甘家口街道', '甘家口街道', '116.319992', '39.920059', 5);
INSERT INTO `street` VALUES (110, '110108005', '110108', '八里庄街道', '八里庄街道', '116.301697', '39.927006', 1);
INSERT INTO `street` VALUES (111, '110108006', '110108', '紫竹院街道', '紫竹院街道', '116.3116', '39.943417', 29);
INSERT INTO `street` VALUES (112, '110108007', '110108', '北下关街道', '北下关街道', '116.338242', '39.95776', 3);
INSERT INTO `street` VALUES (113, '110108008', '110108', '北太平庄街道', '北太平庄街道', '116.361931', '39.950478', 2);
INSERT INTO `street` VALUES (114, '110108010', '110108', '学院路街道', '学院路街道', '116.310318', '39.956074', 24);
INSERT INTO `street` VALUES (115, '110108011', '110108', '中关村街道', '中关村街道', '116.317337', '39.97929', 28);
INSERT INTO `street` VALUES (116, '110108012', '110108', '海淀街道', '海淀街道', '116.31134', '39.981155', 6);
INSERT INTO `street` VALUES (117, '110108013', '110108', '青龙桥街道', '青龙桥街道', '116.271385', '40.004307', 11);
INSERT INTO `street` VALUES (118, '110108014', '110108', '清华园街道', '清华园街道', '116.324829', '39.998608', 10);
INSERT INTO `street` VALUES (119, '110108015', '110108', '燕园街道', '燕园街道', '116.311707', '39.98896', 26);
INSERT INTO `street` VALUES (120, '110108016', '110108', '香山街道', '香山街道', '116.20723', '39.993671', 21);
INSERT INTO `street` VALUES (121, '110108017', '110108', '清河街道', '清河街道', '116.345604', '40.028881', 9);
INSERT INTO `street` VALUES (122, '110108018', '110108', '花园路街道', '花园路街道', '116.310318', '39.956074', 7);
INSERT INTO `street` VALUES (123, '110108019', '110108', '西三旗街道', '西三旗街道', '116.360992', '40.034203', 23);
INSERT INTO `street` VALUES (124, '110108020', '110108', '马连洼街道', '马连洼街道', '116.291893', '40.032803', 8);
INSERT INTO `street` VALUES (125, '110108021', '110108', '田村路街道', '田村路街道', '116.310318', '39.956074', 17);
INSERT INTO `street` VALUES (126, '110108022', '110108', '上地街道', '上地街道', '116.313126', '40.031029', 12);
INSERT INTO `street` VALUES (127, '110108023', '110108', '万柳', '万柳', '116.310318', '39.956074', 18);
INSERT INTO `street` VALUES (128, '110108024', '110108', '东升', '东升', '116.334396', '39.9953', 4);
INSERT INTO `street` VALUES (129, '110108025', '110108', '曙光街道', '曙光街道', '116.310318', '39.956074', 14);
INSERT INTO `street` VALUES (130, '110108026', '110108', '温泉', '温泉', '116.310318', '39.956074', 20);
INSERT INTO `street` VALUES (131, '110108027', '110108', '四季青', '四季青', '116.274788', '39.95467', 15);
INSERT INTO `street` VALUES (132, '110108028', '110108', '西北旺', '西北旺', '116.263611', '40.04834', 22);
INSERT INTO `street` VALUES (133, '110108029', '110108', '苏家坨', '苏家坨', '116.164581', '40.080269', 16);
INSERT INTO `street` VALUES (134, '110108030', '110108', '上庄', '上庄', '116.213127', '40.109314', 13);
INSERT INTO `street` VALUES (135, '110109001', '110109', '大峪街道', '大峪街道', '116.105377', '39.937183', 3);
INSERT INTO `street` VALUES (136, '110109002', '110109', '城子街道', '城子街道', '116.100075', '39.950085', 1);
INSERT INTO `street` VALUES (137, '110109003', '110109', '东辛房街道', '东辛房街道', '116.068314', '39.930557', 4);
INSERT INTO `street` VALUES (138, '110109004', '110109', '大台街道', '大台街道', '115.941231', '39.965275', 2);
INSERT INTO `street` VALUES (139, '110109005', '110109', '王平', '王平', '115.991081', '39.970787', 10);
INSERT INTO `street` VALUES (140, '110109006', '110109', '永定', '永定', '116.105377', '39.937183', 12);
INSERT INTO `street` VALUES (141, '110109007', '110109', '龙泉', '龙泉', '116.105377', '39.937183', 6);
INSERT INTO `street` VALUES (142, '110109101', '110109', '潭柘寺镇', '潭柘寺镇', '116.030296', '39.878857', 9);
INSERT INTO `street` VALUES (143, '110109104', '110109', '军庄镇', '军庄镇', '116.103455', '40.003696', 5);
INSERT INTO `street` VALUES (144, '110109105', '110109', '雁翅镇', '雁翅镇', '115.83194', '40.018093', 11);
INSERT INTO `street` VALUES (145, '110109106', '110109', '斋堂镇', '斋堂镇', '115.696526', '39.972404', 13);
INSERT INTO `street` VALUES (146, '110109107', '110109', '清水镇', '清水镇', '115.612823', '39.94273', 8);
INSERT INTO `street` VALUES (147, '110109108', '110109', '妙峰山镇', '妙峰山镇', '116.05024', '39.9757', 7);
INSERT INTO `street` VALUES (148, '110111001', '110111', '城关街道', '城关街道', '115.985153', '39.692829', 1);
INSERT INTO `street` VALUES (149, '110111002', '110111', '新镇街道', '新镇街道', '116.06031', '39.735687', 22);
INSERT INTO `street` VALUES (150, '110111004', '110111', '向阳街道', '向阳街道', '115.938438', '39.741043', 18);
INSERT INTO `street` VALUES (151, '110111005', '110111', '东风街道', '东风街道', '115.963303', '39.755089', 4);
INSERT INTO `street` VALUES (152, '110111006', '110111', '迎风街道', '迎风街道', '115.951492', '39.726887', 24);
INSERT INTO `street` VALUES (153, '110111007', '110111', '星城街道', '星城街道', '116.064255', '39.71352', 21);
INSERT INTO `street` VALUES (154, '110111008', '110111', '良乡', '良乡', '116.13916', '39.735535', 10);
INSERT INTO `street` VALUES (155, '110111009', '110111', '周口店', '周口店', '115.951416', '39.680836', 28);
INSERT INTO `street` VALUES (156, '110111010', '110111', '琉璃河', '琉璃河', '116.033218', '39.610653', 11);
INSERT INTO `street` VALUES (157, '110111011', '110111', '拱辰街道', '拱辰街道', '116.13916', '39.735535', 7);
INSERT INTO `street` VALUES (158, '110111012', '110111', '西潞街道', '西潞街道', '116.13916', '39.735535', 20);
INSERT INTO `street` VALUES (159, '110111101', '110111', '阎村镇', '阎村镇', '116.097092', '39.717457', 23);
INSERT INTO `street` VALUES (160, '110111103', '110111', '窦店镇', '窦店镇', '116.068581', '39.651562', 5);
INSERT INTO `street` VALUES (161, '110111104', '110111', '石楼镇', '石楼镇', '115.984932', '39.655571', 17);
INSERT INTO `street` VALUES (162, '110111105', '110111', '长阳镇', '长阳镇', '116.216995', '39.765163', 27);
INSERT INTO `street` VALUES (163, '110111107', '110111', '河北镇', '河北镇', '115.93927', '39.820038', 9);
INSERT INTO `street` VALUES (164, '110111108', '110111', '长沟镇', '长沟镇', '115.900833', '39.580128', 26);
INSERT INTO `street` VALUES (165, '110111109', '110111', '大石窝镇', '大石窝镇', '115.826035', '39.552765', 3);
INSERT INTO `street` VALUES (166, '110111110', '110111', '张坊镇', '张坊镇', '115.717293', '39.576435', 25);
INSERT INTO `street` VALUES (167, '110111111', '110111', '十渡镇', '十渡镇', '115.58934', '39.639843', 15);
INSERT INTO `street` VALUES (168, '110111112', '110111', '青龙湖镇', '青龙湖镇', '116.039085', '39.776115', 14);
INSERT INTO `street` VALUES (169, '110111115', '110111', '韩村河镇', '韩村河镇', '115.972313', '39.60199', 8);
INSERT INTO `street` VALUES (170, '110111208', '110111', '霞云岭乡', '霞云岭乡', '115.751366', '39.728802', 19);
INSERT INTO `street` VALUES (171, '110111209', '110111', '南窖乡', '南窖乡', '115.842033', '39.768734', 12);
INSERT INTO `street` VALUES (172, '110111210', '110111', '佛子庄乡', '佛子庄乡', '115.890305', '39.820843', 6);
INSERT INTO `street` VALUES (173, '110111211', '110111', '大安山乡', '大安山乡', '115.791595', '39.886387', 2);
INSERT INTO `street` VALUES (174, '110111212', '110111', '史家营乡', '史家营乡', '115.676231', '39.859928', 16);
INSERT INTO `street` VALUES (175, '110111213', '110111', '蒲洼乡', '蒲洼乡', '115.54641', '39.739189', 13);
INSERT INTO `street` VALUES (176, '110112001', '110112', '中仓街道', '中仓街道', '116.660721', '39.903801', 15);
INSERT INTO `street` VALUES (177, '110112002', '110112', '新华街道', '新华街道', '116.66893', '39.913754', 9);
INSERT INTO `street` VALUES (178, '110112003', '110112', '北苑街道', '北苑街道', '116.647346', '39.904167', 1);
INSERT INTO `street` VALUES (179, '110112004', '110112', '玉桥街道', '玉桥街道', '116.679749', '39.89476', 13);
INSERT INTO `street` VALUES (180, '110112005', '110112', '永顺', '永顺', '116.6586', '39.902485', 11);
INSERT INTO `street` VALUES (181, '110112006', '110112', '梨园', '梨园', '116.662811', '39.86639', 3);
INSERT INTO `street` VALUES (182, '110112104', '110112', '宋庄镇', '宋庄镇', '116.727448', '39.940708', 6);
INSERT INTO `street` VALUES (183, '110112105', '110112', '张家湾镇', '张家湾镇', '116.720428', '39.858341', 14);
INSERT INTO `street` VALUES (184, '110112106', '110112', '漷县镇', '漷县镇', '116.793716', '39.779758', 2);
INSERT INTO `street` VALUES (185, '110112109', '110112', '马驹桥镇', '马驹桥镇', '116.560837', '39.749031', 5);
INSERT INTO `street` VALUES (186, '110112110', '110112', '西集镇', '西集镇', '116.881561', '39.816906', 8);
INSERT INTO `street` VALUES (187, '110112114', '110112', '台湖镇', '台湖镇', '116.652199', '39.832069', 7);
INSERT INTO `street` VALUES (188, '110112117', '110112', '永乐店镇', '永乐店镇', '116.796532', '39.708782', 10);
INSERT INTO `street` VALUES (189, '110112119', '110112', '潞城镇', '潞城镇', '116.728889', '39.915855', 4);
INSERT INTO `street` VALUES (190, '110112209', '110112', '于家务回族乡', '于家务回族乡', '116.703735', '39.718834', 12);
INSERT INTO `street` VALUES (191, '110113001', '110113', '胜利街道', '胜利街道', '116.644608', '40.135448', 18);
INSERT INTO `street` VALUES (192, '110113002', '110113', '光明街道', '光明街道', '116.663834', '40.130405', 6);
INSERT INTO `street` VALUES (193, '110113003', '110113', '仁和', '仁和', '116.665405', '40.107895', 17);
INSERT INTO `street` VALUES (194, '110113004', '110113', '后沙峪', '后沙峪', '116.544052', '40.104713', 7);
INSERT INTO `street` VALUES (195, '110113005', '110113', '天竺', '天竺', '116.653526', '40.128937', 21);
INSERT INTO `street` VALUES (196, '110113006', '110113', '杨镇', '杨镇', '116.830933', '40.153427', 23);
INSERT INTO `street` VALUES (197, '110113007', '110113', '牛栏山', '牛栏山', '116.654907', '40.210587', 16);
INSERT INTO `street` VALUES (198, '110113008', '110113', '南法信', '南法信', '116.610886', '40.118973', 15);
INSERT INTO `street` VALUES (199, '110113009', '110113', '马坡', '马坡', '116.656021', '40.175259', 12);
INSERT INTO `street` VALUES (200, '110113010', '110113', '石园街道', '石园街道', '116.653526', '40.128937', 19);
INSERT INTO `street` VALUES (201, '110113011', '110113', '空港街道', '空港街道', '116.653526', '40.128937', 8);
INSERT INTO `street` VALUES (202, '110113012', '110113', '双丰街道', '双丰街道', '116.653526', '40.128937', 20);
INSERT INTO `street` VALUES (203, '110113013', '110113', '旺泉街道', '旺泉街道', '116.653526', '40.128937', 22);
INSERT INTO `street` VALUES (204, '110113101', '110113', '高丽营镇', '高丽营镇', '116.499863', '40.159077', 5);
INSERT INTO `street` VALUES (205, '110113104', '110113', '李桥镇', '李桥镇', '116.644409', '40.060104', 9);
INSERT INTO `street` VALUES (206, '110113105', '110113', '李遂镇', '李遂镇', '116.757271', '40.090916', 10);
INSERT INTO `street` VALUES (207, '110113106', '110113', '南彩镇', '南彩镇', '116.71122', '40.134033', 14);
INSERT INTO `street` VALUES (208, '110113108', '110113', '北务镇', '北务镇', '116.828636', '40.070171', 2);
INSERT INTO `street` VALUES (209, '110113109', '110113', '大孙各庄镇', '大孙各庄镇', '116.919495', '40.087181', 4);
INSERT INTO `street` VALUES (210, '110113110', '110113', '张镇', '张镇', '116.951141', '40.151634', 24);
INSERT INTO `street` VALUES (211, '110113111', '110113', '龙湾屯镇', '龙湾屯镇', '116.869179', '40.224342', 11);
INSERT INTO `street` VALUES (212, '110113112', '110113', '木林镇', '木林镇', '116.780861', '40.245693', 13);
INSERT INTO `street` VALUES (213, '110113113', '110113', '北小营镇', '北小营镇', '116.728714', '40.199886', 3);
INSERT INTO `street` VALUES (214, '110113115', '110113', '北石槽镇', '北石槽镇', '116.534439', '40.25042', 1);
INSERT INTO `street` VALUES (215, '110113116', '110113', '赵全营镇', '赵全营镇', '116.604355', '40.213955', 25);
INSERT INTO `street` VALUES (216, '110114001', '110114', '城北街道', '城北街道', '116.233818', '40.226383', 3);
INSERT INTO `street` VALUES (217, '110114002', '110114', '南口', '南口', '116.235909', '40.218086', 11);
INSERT INTO `street` VALUES (218, '110114003', '110114', '马池口', '马池口', '116.168777', '40.182747', 10);
INSERT INTO `street` VALUES (219, '110114004', '110114', '沙河', '沙河', '116.235909', '40.218086', 13);
INSERT INTO `street` VALUES (220, '110114005', '110114', '城南街道', '城南街道', '116.235909', '40.218086', 4);
INSERT INTO `street` VALUES (221, '110114006', '110114', '回龙观', '回龙观', '116.324768', '40.064262', 7);
INSERT INTO `street` VALUES (222, '110114007', '110114', '东小口', '东小口', '116.408752', '40.05817', 6);
INSERT INTO `street` VALUES (223, '110114008', '110114', '天通苑北街道', '天通苑北街道', '116.235909', '40.218086', 15);
INSERT INTO `street` VALUES (224, '110114009', '110114', '天通苑南街道', '天通苑南街道', '116.235909', '40.218086', 16);
INSERT INTO `street` VALUES (225, '110114010', '110114', '霍营街道', '霍营街道', '116.235909', '40.218086', 8);
INSERT INTO `street` VALUES (226, '110114104', '110114', '阳坊镇', '阳坊镇', '116.139954', '40.138474', 19);
INSERT INTO `street` VALUES (227, '110114110', '110114', '小汤山镇', '小汤山镇', '116.399765', '40.177315', 17);
INSERT INTO `street` VALUES (228, '110114111', '110114', '南邵镇', '南邵镇', '116.286171', '40.207729', 12);
INSERT INTO `street` VALUES (229, '110114112', '110114', '崔村镇', '崔村镇', '116.353096', '40.220581', 5);
INSERT INTO `street` VALUES (230, '110114113', '110114', '百善镇', '百善镇', '116.320366', '40.16724', 1);
INSERT INTO `street` VALUES (231, '110114115', '110114', '北七家镇', '北七家镇', '116.424767', '40.117943', 2);
INSERT INTO `street` VALUES (232, '110114116', '110114', '兴寿镇', '兴寿镇', '116.409554', '40.214409', 18);
INSERT INTO `street` VALUES (233, '110114118', '110114', '流村镇', '流村镇', '116.064659', '40.182697', 9);
INSERT INTO `street` VALUES (234, '110114119', '110114', '十三陵镇', '十三陵镇', '116.22493', '40.272087', 14);
INSERT INTO `street` VALUES (235, '110114120', '110114', '延寿镇', '延寿镇', '116.235909', '40.218086', 20);
INSERT INTO `street` VALUES (236, '110115001', '110115', '兴丰街道', '兴丰街道', '116.338036', '39.728909', 17);
INSERT INTO `street` VALUES (237, '110115002', '110115', '林校路街道', '林校路街道', '116.338036', '39.728909', 9);
INSERT INTO `street` VALUES (238, '110115003', '110115', '清源街道', '清源街道', '116.338036', '39.728909', 12);
INSERT INTO `street` VALUES (239, '110115004', '110115', '亦庄', '亦庄', '116.481903', '39.800163', 19);
INSERT INTO `street` VALUES (240, '110115005', '110115', '黄村', '黄村', '116.340256', '39.72773', 7);
INSERT INTO `street` VALUES (241, '110115006', '110115', '旧宫', '旧宫', '116.445854', '39.804882', 8);
INSERT INTO `street` VALUES (242, '110115007', '110115', '西红门', '西红门', '116.350479', '39.790298', 16);
INSERT INTO `street` VALUES (243, '110115008', '110115', '瀛海', '瀛海', '116.452293', '39.756207', 18);
INSERT INTO `street` VALUES (244, '110115009', '110115', '观音寺街道', '观音寺街道', '116.338036', '39.728909', 5);
INSERT INTO `street` VALUES (245, '110115010', '110115', '天宫院街道', '天宫院街道', '116.338036', '39.728909', 14);
INSERT INTO `street` VALUES (246, '110115103', '110115', '青云店镇', '青云店镇', '116.501617', '39.685539', 13);
INSERT INTO `street` VALUES (247, '110115104', '110115', '采育镇', '采育镇', '116.666641', '39.652382', 4);
INSERT INTO `street` VALUES (248, '110115105', '110115', '安定镇', '安定镇', '116.499931', '39.617622', 1);
INSERT INTO `street` VALUES (249, '110115106', '110115', '礼贤镇', '礼贤镇', '116.435577', '39.556927', 10);
INSERT INTO `street` VALUES (250, '110115107', '110115', '榆垡镇', '榆垡镇', '116.315468', '39.510513', 20);
INSERT INTO `street` VALUES (251, '110115108', '110115', '庞各庄镇', '庞各庄镇', '116.324249', '39.63475', 11);
INSERT INTO `street` VALUES (252, '110115109', '110115', '北臧村镇', '北臧村镇', '116.30262', '39.686275', 3);
INSERT INTO `street` VALUES (253, '110115110', '110115', '魏善庄镇', '魏善庄镇', '116.414673', '39.631481', 15);
INSERT INTO `street` VALUES (254, '110115111', '110115', '长子营镇', '长子营镇', '116.596069', '39.684967', 21);
INSERT INTO `street` VALUES (255, '110115403', '110115', '北京经济技术开发区', '北京经济技术开发区', '116.338036', '39.728909', 2);
INSERT INTO `street` VALUES (256, '110115404', '110115', '中关村国家自主创新示范区大兴生物医药产业基地', '中关村国家自主创新示范区大兴生物医药产业基地', '116.338036', '39.728909', 22);
INSERT INTO `street` VALUES (257, '110115405', '110115', '国家新媒体产业基地', '国家新媒体产业基地', '116.338036', '39.728909', 6);
INSERT INTO `street` VALUES (258, '110116001', '110116', '泉河街道', '泉河街道', '116.637123', '40.324272', 13);
INSERT INTO `street` VALUES (259, '110116002', '110116', '龙山街道', '龙山街道', '116.637123', '40.324272', 10);
INSERT INTO `street` VALUES (260, '110116003', '110116', '怀柔', '怀柔', '116.640656', '40.302105', 6);
INSERT INTO `street` VALUES (261, '110116004', '110116', '雁栖', '雁栖', '116.658119', '40.359653', 16);
INSERT INTO `street` VALUES (262, '110116005', '110116', '庙城', '庙城', '116.634979', '40.292679', 11);
INSERT INTO `street` VALUES (263, '110116102', '110116', '北房镇', '北房镇', '116.702866', '40.326294', 2);
INSERT INTO `street` VALUES (264, '110116103', '110116', '杨宋镇', '杨宋镇', '116.685577', '40.291607', 15);
INSERT INTO `street` VALUES (265, '110116105', '110116', '桥梓镇', '桥梓镇', '116.574066', '40.290497', 12);
INSERT INTO `street` VALUES (266, '110116106', '110116', '怀北镇', '怀北镇', '116.689476', '40.388874', 5);
INSERT INTO `street` VALUES (267, '110116107', '110116', '汤河口镇', '汤河口镇', '116.645279', '40.737061', 14);
INSERT INTO `street` VALUES (268, '110116108', '110116', '渤海镇', '渤海镇', '116.46714', '40.414944', 4);
INSERT INTO `street` VALUES (269, '110116109', '110116', '九渡河镇', '九渡河镇', '116.469849', '40.361797', 7);
INSERT INTO `street` VALUES (270, '110116110', '110116', '琉璃庙镇', '琉璃庙镇', '116.608925', '40.587994', 9);
INSERT INTO `street` VALUES (271, '110116111', '110116', '宝山镇', '宝山镇', '116.569923', '40.694778', 1);
INSERT INTO `street` VALUES (272, '110116211', '110116', '长哨营满族乡', '长哨营满族乡', '116.749069', '40.794495', 17);
INSERT INTO `street` VALUES (273, '110116213', '110116', '喇叭沟门满族乡', '喇叭沟门满族乡', '116.621941', '40.902462', 8);
INSERT INTO `street` VALUES (274, '110116400', '110116', '北京雁栖经济开发区', '北京雁栖经济开发区', '116.666367', '40.363369', 3);
INSERT INTO `street` VALUES (275, '110117001', '110117', '滨河街道', '滨河街道', '117.119339', '40.156559', 1);
INSERT INTO `street` VALUES (276, '110117002', '110117', '兴谷街道', '兴谷街道', '117.112335', '40.144783', 14);
INSERT INTO `street` VALUES (277, '110117003', '110117', '渔阳', '渔阳', '117.112335', '40.144783', 17);
INSERT INTO `street` VALUES (278, '110117004', '110117', '峪口', '峪口', '117.017563', '40.184242', 16);
INSERT INTO `street` VALUES (279, '110117005', '110117', '马坊', '马坊', '117.011803', '40.060158', 9);
INSERT INTO `street` VALUES (280, '110117006', '110117', '金海湖', '金海湖', '117.266624', '40.179852', 6);
INSERT INTO `street` VALUES (281, '110117101', '110117', '东高村镇', '东高村镇', '117.114128', '40.103111', 4);
INSERT INTO `street` VALUES (282, '110117102', '110117', '山东庄镇', '山东庄镇', '117.158562', '40.188156', 11);
INSERT INTO `street` VALUES (283, '110117104', '110117', '南独乐河镇', '南独乐河镇', '117.226959', '40.172302', 10);
INSERT INTO `street` VALUES (284, '110117105', '110117', '大华山镇', '大华山镇', '117.065697', '40.27763', 2);
INSERT INTO `street` VALUES (285, '110117106', '110117', '夏各庄镇', '夏各庄镇', '117.175079', '40.124405', 13);
INSERT INTO `street` VALUES (286, '110117108', '110117', '马昌营镇', '马昌营镇', '117.022026', '40.134289', 8);
INSERT INTO `street` VALUES (287, '110117110', '110117', '王辛庄镇', '王辛庄镇', '117.103806', '40.160812', 12);
INSERT INTO `street` VALUES (288, '110117111', '110117', '大兴庄镇', '大兴庄镇', '117.041969', '40.145245', 3);
INSERT INTO `street` VALUES (289, '110117112', '110117', '刘家店镇', '刘家店镇', '117.022041', '40.240158', 7);
INSERT INTO `street` VALUES (290, '110117114', '110117', '镇罗营镇', '镇罗营镇', '117.149467', '40.345036', 18);
INSERT INTO `street` VALUES (291, '110117213', '110117', '黄松峪乡', '黄松峪乡', '117.267151', '40.23798', 5);
INSERT INTO `street` VALUES (292, '110117214', '110117', '熊儿寨乡', '熊儿寨乡', '117.134155', '40.284981', 15);
INSERT INTO `street` VALUES (293, '110228001', '110228', '鼓楼街道', '鼓楼街道', '116.843353', '40.377361', 9);
INSERT INTO `street` VALUES (294, '110228002', '110228', '果园街道', '果园街道', '116.843353', '40.377361', 10);
INSERT INTO `street` VALUES (295, '110228003', '110228', '檀营', '檀营', '116.855606', '40.378029', 18);
INSERT INTO `street` VALUES (296, '110228100', '110228', '密云镇', '密云镇', '116.840576', '40.368874', 13);
INSERT INTO `street` VALUES (297, '110228101', '110228', '溪翁庄镇', '溪翁庄镇', '116.854149', '40.474804', 21);
INSERT INTO `street` VALUES (298, '110228102', '110228', '西田各庄镇', '西田各庄镇', '116.77121', '40.400902', 20);
INSERT INTO `street` VALUES (299, '110228103', '110228', '十里堡镇', '十里堡镇', '116.802032', '40.35799', 16);
INSERT INTO `street` VALUES (300, '110228104', '110228', '河南寨镇', '河南寨镇', '116.827202', '40.331295', 11);
INSERT INTO `street` VALUES (301, '110228105', '110228', '巨各庄镇', '巨各庄镇', '116.947968', '40.381695', 12);
INSERT INTO `street` VALUES (302, '110228106', '110228', '穆家峪镇', '穆家峪镇', '116.944038', '40.411942', 14);
INSERT INTO `street` VALUES (303, '110228107', '110228', '太师屯镇', '太师屯镇', '117.12851', '40.53801', 17);
INSERT INTO `street` VALUES (304, '110228108', '110228', '高岭镇', '高岭镇', '117.120399', '40.603386', 7);
INSERT INTO `street` VALUES (305, '110228109', '110228', '不老屯镇', '不老屯镇', '116.977524', '40.567146', 3);
INSERT INTO `street` VALUES (306, '110228110', '110228', '冯家峪镇', '冯家峪镇', '116.875786', '40.620216', 6);
INSERT INTO `street` VALUES (307, '110228111', '110228', '古北口镇', '古北口镇', '117.163765', '40.691685', 8);
INSERT INTO `street` VALUES (308, '110228112', '110228', '大城子镇', '大城子镇', '117.109665', '40.392937', 4);
INSERT INTO `street` VALUES (309, '110228113', '110228', '东邵渠镇', '东邵渠镇', '116.967842', '40.293613', 5);
INSERT INTO `street` VALUES (310, '110228114', '110228', '北庄镇', '北庄镇', '117.180954', '40.509491', 2);
INSERT INTO `street` VALUES (311, '110228115', '110228', '新城子镇', '新城子镇', '117.334717', '40.644043', 19);
INSERT INTO `street` VALUES (312, '110228116', '110228', '石城镇', '石城镇', '116.819672', '40.54126', 15);
INSERT INTO `street` VALUES (313, '110228400', '110228', '北京密云经济开发区', '北京密云经济开发区', '116.843353', '40.377361', 1);
INSERT INTO `street` VALUES (314, '110229001', '110229', '百泉街道', '百泉街道', '115.985008', '40.465324', 2);
INSERT INTO `street` VALUES (315, '110229002', '110229', '香水园街道', '香水园街道', '115.985008', '40.465324', 13);
INSERT INTO `street` VALUES (316, '110229003', '110229', '儒林街道', '儒林街道', '115.985008', '40.465324', 10);
INSERT INTO `street` VALUES (317, '110229100', '110229', '延庆镇', '延庆镇', '115.98497', '40.458649', 15);
INSERT INTO `street` VALUES (318, '110229101', '110229', '康庄镇', '康庄镇', '115.900131', '40.382523', 7);
INSERT INTO `street` VALUES (319, '110229102', '110229', '八达岭镇', '八达岭镇', '115.972588', '40.364788', 1);
INSERT INTO `street` VALUES (320, '110229103', '110229', '永宁镇', '永宁镇', '116.170418', '40.530075', 16);
INSERT INTO `street` VALUES (321, '110229104', '110229', '旧县镇', '旧县镇', '116.087563', '40.550392', 6);
INSERT INTO `street` VALUES (322, '110229105', '110229', '张山营镇', '张山营镇', '115.844231', '40.476929', 17);
INSERT INTO `street` VALUES (323, '110229106', '110229', '四海镇', '四海镇', '116.413284', '40.531544', 12);
INSERT INTO `street` VALUES (324, '110229107', '110229', '千家店镇', '千家店镇', '116.346474', '40.693558', 9);
INSERT INTO `street` VALUES (325, '110229108', '110229', '沈家营镇', '沈家营镇', '116.04557', '40.481617', 11);
INSERT INTO `street` VALUES (326, '110229109', '110229', '大榆树镇', '大榆树镇', '116.029236', '40.435627', 3);
INSERT INTO `street` VALUES (327, '110229110', '110229', '井庄镇', '井庄镇', '116.103531', '40.468281', 5);
INSERT INTO `street` VALUES (328, '110229207', '110229', '大庄科乡', '大庄科乡', '116.235611', '40.432163', 4);
INSERT INTO `street` VALUES (329, '110229209', '110229', '刘斌堡乡', '刘斌堡乡', '116.226036', '40.567707', 8);
INSERT INTO `street` VALUES (330, '110229210', '110229', '香营乡', '香营乡', '116.145584', '40.571156', 14);
INSERT INTO `street` VALUES (331, '110229214', '110229', '珍珠泉乡', '珍珠泉乡', '116.425453', '40.56036', 18);
INSERT INTO `street` VALUES (332, '120101001', '120101', '劝业场街道', '劝业场街道', '117.200333', '39.123306', 3);
INSERT INTO `street` VALUES (333, '120101002', '120101', '小白楼街道', '小白楼街道', '117.210976', '39.116837', 5);
INSERT INTO `street` VALUES (334, '120101003', '120101', '体育馆街道', '体育馆街道', '117.200356', '39.110371', 4);
INSERT INTO `street` VALUES (335, '120101004', '120101', '新兴街道', '新兴街道', '117.186043', '39.102882', 6);
INSERT INTO `street` VALUES (336, '120101005', '120101', '南营门街道', '南营门街道', '117.184494', '39.118805', 2);
INSERT INTO `street` VALUES (337, '120101006', '120101', '南市街道', '南市街道', '117.187027', '39.131435', 1);
INSERT INTO `street` VALUES (338, '120102001', '120102', '大王庄街道', '大王庄街道', '117.221672', '39.1278', 3);
INSERT INTO `street` VALUES (339, '120102002', '120102', '大直沽街道', '大直沽街道', '117.246384', '39.109383', 4);
INSERT INTO `street` VALUES (340, '120102003', '120102', '中山门街道', '中山门街道', '117.269997', '39.101902', 13);
INSERT INTO `street` VALUES (341, '120102004', '120102', '富民路街道', '富民路街道', '117.22657', '39.122124', 7);
INSERT INTO `street` VALUES (342, '120102005', '120102', '二号桥街道', '二号桥街道', '117.289703', '39.09922', 6);
INSERT INTO `street` VALUES (343, '120102006', '120102', '春华街道', '春华街道', '117.212059', '39.14069', 2);
INSERT INTO `street` VALUES (344, '120102007', '120102', '唐家口街道', '唐家口街道', '117.240021', '39.125698', 10);
INSERT INTO `street` VALUES (345, '120102008', '120102', '向阳楼街道', '向阳楼街道', '117.246269', '39.136387', 12);
INSERT INTO `street` VALUES (346, '120102009', '120102', '常州道街道', '常州道街道', '117.22657', '39.122124', 1);
INSERT INTO `street` VALUES (347, '120102010', '120102', '上杭路街道', '上杭路街道', '117.22657', '39.122124', 9);
INSERT INTO `street` VALUES (348, '120102011', '120102', '东新街道', '东新街道', '117.27684', '39.142681', 5);
INSERT INTO `street` VALUES (349, '120102012', '120102', '鲁山道街道', '鲁山道街道', '117.281731', '39.149414', 8);
INSERT INTO `street` VALUES (350, '120102013', '120102', '天津铁厂街道', '天津铁厂街道', '117.22657', '39.122124', 11);
INSERT INTO `street` VALUES (351, '120103001', '120103', '大营门街道', '大营门街道', '117.215118', '39.108627', 2);
INSERT INTO `street` VALUES (352, '120103002', '120103', '下瓦房街道', '下瓦房街道', '117.226059', '39.106232', 11);
INSERT INTO `street` VALUES (353, '120103003', '120103', '桃园街道', '桃园街道', '117.213661', '39.101925', 9);
INSERT INTO `street` VALUES (354, '120103004', '120103', '挂甲寺街道', '挂甲寺街道', '117.221725', '39.09803', 4);
INSERT INTO `street` VALUES (355, '120103005', '120103', '马场街道', '马场街道', '117.198784', '39.098278', 7);
INSERT INTO `street` VALUES (356, '120103006', '120103', '越秀路街道', '越秀路街道', '117.217537', '39.101898', 13);
INSERT INTO `street` VALUES (357, '120103007', '120103', '友谊路街道', '友谊路街道', '117.217537', '39.101898', 12);
INSERT INTO `street` VALUES (358, '120103008', '120103', '天塔街道', '天塔街道', '117.185616', '39.08149', 10);
INSERT INTO `street` VALUES (359, '120103009', '120103', '尖山街道', '尖山街道', '117.225677', '39.088924', 5);
INSERT INTO `street` VALUES (360, '120103010', '120103', '陈塘庄街道', '陈塘庄街道', '117.26503', '39.067825', 1);
INSERT INTO `street` VALUES (361, '120103011', '120103', '柳林街道', '柳林街道', '117.273239', '39.065231', 6);
INSERT INTO `street` VALUES (362, '120103012', '120103', '东海街道', '东海街道', '117.263962', '39.05608', 3);
INSERT INTO `street` VALUES (363, '120103013', '120103', '梅江街道', '梅江街道', '117.217537', '39.101898', 8);
INSERT INTO `street` VALUES (364, '120104001', '120104', '长虹街道', '长虹街道', '117.150513', '39.138432', 12);
INSERT INTO `street` VALUES (365, '120104002', '120104', '鼓楼街道', '鼓楼街道', '117.183838', '39.139648', 2);
INSERT INTO `street` VALUES (366, '120104003', '120104', '兴南街道', '兴南街道', '117.176666', '39.126137', 10);
INSERT INTO `street` VALUES (367, '120104004', '120104', '广开街道', '广开街道', '117.169006', '39.129494', 1);
INSERT INTO `street` VALUES (368, '120104005', '120104', '万兴街道', '万兴街道', '117.17392', '39.120296', 8);
INSERT INTO `street` VALUES (369, '120104006', '120104', '学府街道', '学府街道', '117.168167', '39.112423', 11);
INSERT INTO `street` VALUES (370, '120104007', '120104', '向阳路街道', '向阳路街道', '117.164146', '39.120476', 9);
INSERT INTO `street` VALUES (371, '120104008', '120104', '嘉陵道街道', '嘉陵道街道', '117.164146', '39.120476', 4);
INSERT INTO `street` VALUES (372, '120104009', '120104', '王顶堤街道', '王顶堤街道', '117.144806', '39.102852', 7);
INSERT INTO `street` VALUES (373, '120104010', '120104', '水上公园街道', '水上公园街道', '117.164146', '39.120476', 5);
INSERT INTO `street` VALUES (374, '120104011', '120104', '体育中心街道', '体育中心街道', '117.190186', '39.125595', 6);
INSERT INTO `street` VALUES (375, '120104012', '120104', '华苑街道', '华苑街道', '117.126976', '39.085709', 3);
INSERT INTO `street` VALUES (376, '120105001', '120105', '光复道街道', '光复道街道', '117.201569', '39.156631', 1);
INSERT INTO `street` VALUES (377, '120105002', '120105', '望海楼街道', '望海楼街道', '117.201439', '39.152077', 8);
INSERT INTO `street` VALUES (378, '120105003', '120105', '鸿顺里街道', '鸿顺里街道', '117.193993', '39.160461', 2);
INSERT INTO `street` VALUES (379, '120105004', '120105', '新开河街道', '新开河街道', '117.201569', '39.156631', 9);
INSERT INTO `street` VALUES (380, '120105005', '120105', '铁东路街道', '铁东路街道', '117.201569', '39.156631', 6);
INSERT INTO `street` VALUES (381, '120105006', '120105', '建昌道街道', '建昌道街道', '117.201569', '39.156631', 3);
INSERT INTO `street` VALUES (382, '120105007', '120105', '宁园街道', '宁园街道', '117.219398', '39.16222', 5);
INSERT INTO `street` VALUES (383, '120105008', '120105', '王串场街道', '王串场街道', '117.229279', '39.159946', 7);
INSERT INTO `street` VALUES (384, '120105009', '120105', '江都路街道', '江都路街道', '117.201569', '39.156631', 4);
INSERT INTO `street` VALUES (385, '120105010', '120105', '月牙河街道', '月牙河街道', '117.246582', '39.163166', 10);
INSERT INTO `street` VALUES (386, '120106001', '120106', '西于庄街道', '西于庄街道', '117.162155', '39.165112', 10);
INSERT INTO `street` VALUES (387, '120106002', '120106', '双环村街道', '双环村街道', '117.132507', '39.197826', 7);
INSERT INTO `street` VALUES (388, '120106003', '120106', '咸阳北路街道', '咸阳北路街道', '117.1633', '39.175068', 8);
INSERT INTO `street` VALUES (389, '120106004', '120106', '丁字沽街道', '丁字沽街道', '117.163269', '39.17532', 2);
INSERT INTO `street` VALUES (390, '120106005', '120106', '西沽街道', '西沽街道', '117.173431', '39.163841', 9);
INSERT INTO `street` VALUES (391, '120106006', '120106', '三条石街道', '三条石街道', '117.18383', '39.155525', 5);
INSERT INTO `street` VALUES (392, '120106008', '120106', '邵公庄街道', '邵公庄街道', '117.156319', '39.154076', 6);
INSERT INTO `street` VALUES (393, '120106009', '120106', '芥园街道', '芥园街道', '117.1633', '39.175068', 3);
INSERT INTO `street` VALUES (394, '120106010', '120106', '铃铛阁街道', '铃铛阁街道', '117.157555', '39.145828', 4);
INSERT INTO `street` VALUES (395, '120106011', '120106', '大胡同街道', '大胡同街道', '117.1633', '39.175068', 1);
INSERT INTO `street` VALUES (396, '120110001', '120110', '张贵庄街道', '张贵庄街道', '117.317528', '39.08828', 16);
INSERT INTO `street` VALUES (397, '120110002', '120110', '丰年村街道', '丰年村街道', '117.339783', '39.084461', 5);
INSERT INTO `street` VALUES (398, '120110003', '120110', '万新街道', '万新街道', '117.313965', '39.087765', 13);
INSERT INTO `street` VALUES (399, '120110004', '120110', '无瑕街道', '无瑕街道', '117.498222', '39.038055', 14);
INSERT INTO `street` VALUES (400, '120110005', '120110', '新立街道', '新立街道', '117.344604', '39.087761', 15);
INSERT INTO `street` VALUES (401, '120110006', '120110', '华明街道', '华明街道', '117.393028', '39.168377', 8);
INSERT INTO `street` VALUES (402, '120110007', '120110', '金钟街道', '金钟街道', '117.313965', '39.087765', 10);
INSERT INTO `street` VALUES (403, '120110008', '120110', '军粮城街道', '军粮城街道', '117.313965', '39.087765', 11);
INSERT INTO `street` VALUES (404, '120110009', '120110', '金桥街道', '金桥街道', '117.313965', '39.087765', 9);
INSERT INTO `street` VALUES (405, '120110400', '120110', '开发区西区', '开发区西区', '117.345619', '39.079533', 12);
INSERT INTO `street` VALUES (406, '120110401', '120110', '保税区空港国际物流区', '保税区空港国际物流区', '117.313965', '39.087765', 2);
INSERT INTO `street` VALUES (407, '120110402', '120110', '保税区空港国际物流经济区', '保税区空港国际物流经济区', '117.386017', '39.158119', 1);
INSERT INTO `street` VALUES (408, '120110403', '120110', '东丽区开发区', '东丽区开发区', '117.345619', '39.079533', 4);
INSERT INTO `street` VALUES (409, '120110404', '120110', '东丽湖', '东丽湖', '117.313965', '39.087765', 3);
INSERT INTO `street` VALUES (410, '120110405', '120110', '综合保税区', '综合保税区', '117.313965', '39.087765', 17);
INSERT INTO `street` VALUES (411, '120110406', '120110', '航空新城', '航空新城', '117.313965', '39.087765', 7);
INSERT INTO `street` VALUES (412, '120110407', '120110', '服务滨海新区建设管理委员会', '服务滨海新区建设管理委员会', '117.313965', '39.087765', 6);
INSERT INTO `street` VALUES (413, '120111001', '120111', '西营门街道', '西营门街道', '117.137573', '39.135082', 10);
INSERT INTO `street` VALUES (414, '120111002', '120111', '李七庄街道', '李七庄街道', '117.160744', '39.063332', 4);
INSERT INTO `street` VALUES (415, '120111100', '120111', '中北镇', '中北镇', '117.091827', '39.125881', 13);
INSERT INTO `street` VALUES (416, '120111101', '120111', '杨柳青镇', '杨柳青镇', '117.01516', '39.128418', 11);
INSERT INTO `street` VALUES (417, '120111102', '120111', '辛口镇', '辛口镇', '116.970665', '39.089733', 7);
INSERT INTO `street` VALUES (418, '120111103', '120111', '张家窝镇', '张家窝镇', '117.041962', '39.057449', 12);
INSERT INTO `street` VALUES (419, '120111104', '120111', '精武镇', '精武镇', '117.012245', '39.139446', 2);
INSERT INTO `street` VALUES (420, '120111105', '120111', '大寺镇', '大寺镇', '117.24028', '39.019566', 1);
INSERT INTO `street` VALUES (421, '120111106', '120111', '王稳庄镇', '王稳庄镇', '117.266418', '38.89465', 5);
INSERT INTO `street` VALUES (422, '120111400', '120111', '开发区西青微电子小区', '开发区西青微电子小区', '117.012245', '39.139446', 3);
INSERT INTO `street` VALUES (423, '120111401', '120111', '新技术产业园区', '新技术产业园区', '117.012245', '39.139446', 6);
INSERT INTO `street` VALUES (424, '120111402', '120111', '西青高校区', '西青高校区', '117.012245', '39.139446', 8);
INSERT INTO `street` VALUES (425, '120111450', '120111', '西青区开发区', '西青区开发区', '117.012245', '39.139446', 9);
INSERT INTO `street` VALUES (426, '120112100', '120112', '咸水沽镇', '咸水沽镇', '117.395317', '38.979637', 12);
INSERT INTO `street` VALUES (427, '120112101', '120112', '葛沽镇', '葛沽镇', '117.508858', '38.98872', 3);
INSERT INTO `street` VALUES (428, '120112102', '120112', '小站镇', '小站镇', '117.436836', '38.915871', 13);
INSERT INTO `street` VALUES (429, '120112103', '120112', '双港镇', '双港镇', '117.318779', '39.04285', 8);
INSERT INTO `street` VALUES (430, '120112104', '120112', '辛庄镇', '辛庄镇', '117.350197', '39.02676', 14);
INSERT INTO `street` VALUES (431, '120112106', '120112', '双桥河镇', '双桥河镇', '117.43911', '38.990669', 10);
INSERT INTO `street` VALUES (432, '120112107', '120112', '八里台镇', '八里台镇', '117.316849', '38.945225', 1);
INSERT INTO `street` VALUES (433, '120112108', '120112', '北闸口镇', '北闸口镇', '117.406387', '38.950241', 2);
INSERT INTO `street` VALUES (434, '120112401', '120112', '铁路十八局', '铁路十八局', '117.382545', '38.989578', 11);
INSERT INTO `street` VALUES (435, '120112403', '120112', '长青办事处', '长青办事处', '117.382545', '38.989578', 15);
INSERT INTO `street` VALUES (436, '120112404', '120112', '津南开发区东区', '津南开发区东区', '117.382545', '38.989578', 6);
INSERT INTO `street` VALUES (437, '120112405', '120112', '津南开发区西区', '津南开发区西区', '117.382545', '38.989578', 7);
INSERT INTO `street` VALUES (438, '120112407', '120112', '海河教育园区', '海河教育园区', '117.367874', '39.016758', 4);
INSERT INTO `street` VALUES (439, '120112500', '120112', '双林农场', '双林农场', '117.382545', '38.989578', 9);
INSERT INTO `street` VALUES (440, '120112501', '120112', '津南国家农业园区', '津南国家农业园区', '117.382545', '38.989578', 5);
INSERT INTO `street` VALUES (441, '120113001', '120113', '果园新村街道', '果园新村街道', '117.139488', '39.222561', 3);
INSERT INTO `street` VALUES (442, '120113002', '120113', '集贤里街道', '集贤里街道', '117.136002', '39.226677', 6);
INSERT INTO `street` VALUES (443, '120113003', '120113', '普东街道', '普东街道', '117.207008', '39.20631', 9);
INSERT INTO `street` VALUES (444, '120113004', '120113', '瑞景街道', '瑞景街道', '117.134819', '39.225555', 11);
INSERT INTO `street` VALUES (445, '120113005', '120113', '佳荣里街道', '佳荣里街道', '117.134819', '39.225555', 5);
INSERT INTO `street` VALUES (446, '120113100', '120113', '天穆镇', '天穆镇', '117.14959', '39.201599', 18);
INSERT INTO `street` VALUES (447, '120113101', '120113', '北仓镇', '北仓镇', '117.125557', '39.231594', 1);
INSERT INTO `street` VALUES (448, '120113102', '120113', '双街镇', '双街镇', '117.111153', '39.26144', 12);
INSERT INTO `street` VALUES (449, '120113103', '120113', '双口镇', '双口镇', '117.036827', '39.227383', 13);
INSERT INTO `street` VALUES (450, '120113104', '120113', '青光镇', '青光镇', '117.0597', '39.197212', 10);
INSERT INTO `street` VALUES (451, '120113106', '120113', '宜兴埠镇', '宜兴埠镇', '117.21804', '39.19537', 21);
INSERT INTO `street` VALUES (452, '120113107', '120113', '小淀镇', '小淀镇', '117.225876', '39.247719', 19);
INSERT INTO `street` VALUES (453, '120113108', '120113', '大张庄镇', '大张庄镇', '117.228661', '39.291084', 2);
INSERT INTO `street` VALUES (454, '120113111', '120113', '西堤头镇', '西堤头镇', '117.353661', '39.254375', 20);
INSERT INTO `street` VALUES (455, '120113400', '120113', '科技园区北区', '科技园区北区', '117.134819', '39.225555', 7);
INSERT INTO `street` VALUES (456, '120113401', '120113', '科技园区南区', '科技园区南区', '117.134819', '39.225555', 8);
INSERT INTO `street` VALUES (457, '120113402', '120113', '天津医药医疗器械工业园', '天津医药医疗器械工业园', '117.134819', '39.225555', 17);
INSERT INTO `street` VALUES (458, '120113403', '120113', '天津陆路港物流装备产业园', '天津陆路港物流装备产业园', '117.134819', '39.225555', 16);
INSERT INTO `street` VALUES (459, '120113404', '120113', '天津风电产业园', '天津风电产业园', '117.177704', '39.299534', 15);
INSERT INTO `street` VALUES (460, '120113500', '120113', '红旗农场', '红旗农场', '117.134819', '39.225555', 4);
INSERT INTO `street` VALUES (461, '120113501', '120113', '曙光农场', '曙光农场', '117.134819', '39.225555', 14);
INSERT INTO `street` VALUES (462, '120114001', '120114', '杨村街道', '杨村街道', '117.076546', '39.385315', 37);
INSERT INTO `street` VALUES (463, '120114002', '120114', '下朱庄街道', '下朱庄街道', '117.083687', '39.337723', 35);
INSERT INTO `street` VALUES (464, '120114003', '120114', '东蒲洼街道', '东蒲洼街道', '117.011597', '39.421082', 13);
INSERT INTO `street` VALUES (465, '120114004', '120114', '黄庄街道', '黄庄街道', '117.062569', '39.346176', 19);
INSERT INTO `street` VALUES (466, '120114005', '120114', '徐官屯街道', '徐官屯街道', '117.0849', '39.400043', 36);
INSERT INTO `street` VALUES (467, '120114006', '120114', '运河西街道', '运河西街道', '117.061432', '39.393616', 38);
INSERT INTO `street` VALUES (468, '120114101', '120114', '梅厂镇', '梅厂镇', '117.200737', '39.370178', 21);
INSERT INTO `street` VALUES (469, '120114102', '120114', '大碱厂镇', '大碱厂镇', '117.091583', '39.472462', 8);
INSERT INTO `street` VALUES (470, '120114103', '120114', '崔黄口镇', '崔黄口镇', '117.197906', '39.533817', 6);
INSERT INTO `street` VALUES (471, '120114104', '120114', '大良镇', '大良镇', '117.095268', '39.543831', 9);
INSERT INTO `street` VALUES (472, '120114105', '120114', '下伍旗镇', '下伍旗镇', '117.061646', '39.616997', 34);
INSERT INTO `street` VALUES (473, '120114106', '120114', '南蔡村镇', '南蔡村镇', '117.016403', '39.482166', 22);
INSERT INTO `street` VALUES (474, '120114107', '120114', '大孟庄镇', '大孟庄镇', '116.991501', '39.527367', 10);
INSERT INTO `street` VALUES (475, '120114108', '120114', '泗村店镇', '泗村店镇', '116.959595', '39.478889', 25);
INSERT INTO `street` VALUES (476, '120114109', '120114', '河西务镇', '河西务镇', '116.960052', '39.623558', 17);
INSERT INTO `street` VALUES (477, '120114110', '120114', '城关镇', '城关镇', '116.873611', '39.528656', 4);
INSERT INTO `street` VALUES (478, '120114111', '120114', '东马圈镇', '东马圈镇', '116.841995', '39.44891', 12);
INSERT INTO `street` VALUES (479, '120114112', '120114', '黄花店镇', '黄花店镇', '116.903923', '39.360798', 18);
INSERT INTO `street` VALUES (480, '120114113', '120114', '石各庄镇', '石各庄镇', '116.905609', '39.299419', 24);
INSERT INTO `street` VALUES (481, '120114114', '120114', '王庆坨镇', '王庆坨镇', '116.93161', '39.172379', 26);
INSERT INTO `street` VALUES (482, '120114115', '120114', '汊沽港镇', '汊沽港镇', '116.952423', '39.257633', 3);
INSERT INTO `street` VALUES (483, '120114116', '120114', '河北屯镇', '河北屯镇', '117.129181', '39.579754', 16);
INSERT INTO `street` VALUES (484, '120114117', '120114', '上马台镇', '上马台镇', '117.261284', '39.391277', 23);
INSERT INTO `street` VALUES (485, '120114118', '120114', '大王古庄镇', '大王古庄镇', '116.825951', '39.571404', 11);
INSERT INTO `street` VALUES (486, '120114119', '120114', '陈咀镇', '陈咀镇', '117.057961', '39.376926', 5);
INSERT INTO `street` VALUES (487, '120114120', '120114', '豆张庄镇', '豆张庄镇', '117.057961', '39.376926', 14);
INSERT INTO `street` VALUES (488, '120114121', '120114', '曹子里镇', '曹子里镇', '117.057961', '39.376926', 2);
INSERT INTO `street` VALUES (489, '120114122', '120114', '大黄堡镇', '大黄堡镇', '117.057961', '39.376926', 7);
INSERT INTO `street` VALUES (490, '120114123', '120114', '高村镇', '高村镇', '117.057961', '39.376926', 15);
INSERT INTO `street` VALUES (491, '120114124', '120114', '白古屯镇', '白古屯镇', '117.057961', '39.376926', 1);
INSERT INTO `street` VALUES (492, '120114400', '120114', '开发区武清逸仙园小区', '开发区武清逸仙园小区', '117.032745', '39.409054', 20);
INSERT INTO `street` VALUES (493, '120114401', '120114', '武清区开发区', '武清区开发区', '117.067665', '39.40316', 32);
INSERT INTO `street` VALUES (494, '120114402', '120114', '武清商务区', '武清商务区', '117.067665', '39.40316', 33);
INSERT INTO `street` VALUES (495, '120114403', '120114', '武清京滨园', '武清京滨园', '117.057961', '39.376926', 28);
INSERT INTO `street` VALUES (496, '120114404', '120114', '武清地毯园', '武清地毯园', '117.057961', '39.376926', 27);
INSERT INTO `street` VALUES (497, '120114405', '120114', '武清汽车园', '武清汽车园', '117.057961', '39.376926', 31);
INSERT INTO `street` VALUES (498, '120114406', '120114', '武清科技谷', '武清科技谷', '117.057961', '39.376926', 29);
INSERT INTO `street` VALUES (499, '120114500', '120114', '武清农场', '武清农场', '117.057961', '39.376926', 30);
INSERT INTO `street` VALUES (500, '120115001', '120115', '海滨街道', '海滨街道', '117.30809', '39.716965', 11);
INSERT INTO `street` VALUES (501, '120115002', '120115', '宝平街道', '宝平街道', '117.311264', '39.717319', 2);
INSERT INTO `street` VALUES (502, '120115003', '120115', '钰华街道', '钰华街道', '117.30809', '39.716965', 29);
INSERT INTO `street` VALUES (503, '120115101', '120115', '大口屯镇', '大口屯镇', '117.238075', '39.585228', 4);
INSERT INTO `street` VALUES (504, '120115102', '120115', '大白庄镇', '大白庄镇', '117.388939', '39.449062', 3);
INSERT INTO `street` VALUES (505, '120115103', '120115', '王卜庄镇', '王卜庄镇', '117.447289', '39.687019', 26);
INSERT INTO `street` VALUES (506, '120115104', '120115', '方家庄镇', '方家庄镇', '117.43898', '39.735771', 9);
INSERT INTO `street` VALUES (507, '120115105', '120115', '林亭口镇', '林亭口镇', '117.51519', '39.635067', 19);
INSERT INTO `street` VALUES (508, '120115106', '120115', '八门城镇', '八门城镇', '117.613358', '39.579418', 1);
INSERT INTO `street` VALUES (509, '120115107', '120115', '大钟庄镇', '大钟庄镇', '117.571564', '39.690136', 7);
INSERT INTO `street` VALUES (510, '120115108', '120115', '新安镇', '新安镇', '117.55143', '39.756344', 27);
INSERT INTO `street` VALUES (511, '120115110', '120115', '马家店镇', '马家店镇', '117.276276', '39.660675', 21);
INSERT INTO `street` VALUES (512, '120115111', '120115', '霍各庄镇', '霍各庄镇', '117.382507', '39.753841', 15);
INSERT INTO `street` VALUES (513, '120115113', '120115', '新开口镇', '新开口镇', '117.195091', '39.681381', 28);
INSERT INTO `street` VALUES (514, '120115115', '120115', '大唐庄镇', '大唐庄镇', '117.442894', '39.406868', 5);
INSERT INTO `street` VALUES (515, '120115117', '120115', '高家庄镇', '高家庄镇', '117.284973', '39.74144', 10);
INSERT INTO `street` VALUES (516, '120115118', '120115', '口东镇', '口东镇', '117.371307', '39.679005', 18);
INSERT INTO `street` VALUES (517, '120115119', '120115', '牛道口镇', '牛道口镇', '117.267021', '39.791382', 22);
INSERT INTO `street` VALUES (518, '120115120', '120115', '史各庄镇', '史各庄镇', '117.221649', '39.746986', 24);
INSERT INTO `street` VALUES (519, '120115121', '120115', '郝各庄镇', '郝各庄镇', '117.319641', '39.632153', 12);
INSERT INTO `street` VALUES (520, '120115122', '120115', '周良庄镇', '周良庄镇', '117.380013', '39.565563', 30);
INSERT INTO `street` VALUES (521, '120115123', '120115', '牛家牌镇', '牛家牌镇', '117.30809', '39.716965', 23);
INSERT INTO `street` VALUES (522, '120115124', '120115', '尔王庄镇', '尔王庄镇', '117.30809', '39.716965', 8);
INSERT INTO `street` VALUES (523, '120115125', '120115', '黄庄镇', '黄庄镇', '117.30809', '39.716965', 14);
INSERT INTO `street` VALUES (524, '120115453', '120115', '天宝工业园区', '天宝工业园区', '117.30809', '39.716965', 25);
INSERT INTO `street` VALUES (525, '120115454', '120115', '九园工业园区', '九园工业园区', '117.431068', '39.452316', 17);
INSERT INTO `street` VALUES (526, '120115455', '120115', '京津新城', '京津新城', '117.363113', '39.542801', 16);
INSERT INTO `street` VALUES (527, '120115500', '120115', '里自沽农场', '里自沽农场', '117.30809', '39.716965', 20);
INSERT INTO `street` VALUES (528, '120115501', '120115', '黄庄农场', '黄庄农场', '117.525764', '39.496567', 13);
INSERT INTO `street` VALUES (529, '120115502', '120115', '大钟农场', '大钟农场', '117.30809', '39.716965', 6);
INSERT INTO `street` VALUES (530, '120116001', '120116', '新村街道', '新村街道', '117.647797', '39.023952', 31);
INSERT INTO `street` VALUES (531, '120116002', '120116', '于家堡街道', '于家堡街道', '117.654175', '39.032845', 36);
INSERT INTO `street` VALUES (532, '120116003', '120116', '新港街道', '新港街道', '117.716805', '38.997143', 32);
INSERT INTO `street` VALUES (533, '120116004', '120116', '向阳街道', '向阳街道', '117.199066', '38.686176', 27);
INSERT INTO `street` VALUES (534, '120116005', '120116', '杭州道街道', '杭州道街道', '117.654175', '39.032845', 15);
INSERT INTO `street` VALUES (535, '120116006', '120116', '新河街道', '新河街道', '117.633286', '39.041134', 33);
INSERT INTO `street` VALUES (536, '120116007', '120116', '大沽街道', '大沽街道', '117.682434', '38.98032', 7);
INSERT INTO `street` VALUES (537, '120116008', '120116', '新北街道', '新北街道', '117.654175', '39.032845', 29);
INSERT INTO `street` VALUES (538, '120116009', '120116', '北塘街道', '北塘街道', '117.71656', '39.1059', 2);
INSERT INTO `street` VALUES (539, '120116010', '120116', '渤海石油街道', '渤海石油街道', '117.706573', '38.991039', 5);
INSERT INTO `street` VALUES (540, '120116011', '120116', '胡家园街道', '胡家园街道', '117.602127', '39.026558', 17);
INSERT INTO `street` VALUES (541, '120116031', '120116', '汉沽街道', '汉沽街道', '117.806824', '39.257126', 14);
INSERT INTO `street` VALUES (542, '120116032', '120116', '寨上街道', '寨上街道', '117.654175', '39.032845', 37);
INSERT INTO `street` VALUES (543, '120116033', '120116', '河西街道', '河西街道', '117.786095', '39.246681', 16);
INSERT INTO `street` VALUES (544, '120116051', '120116', '迎宾街道', '迎宾街道', '117.459419', '38.839115', 35);
INSERT INTO `street` VALUES (545, '120116052', '120116', '胜利街道', '胜利街道', '117.452759', '38.835804', 24);
INSERT INTO `street` VALUES (546, '120116053', '120116', '古林街道', '古林街道', '117.480461', '38.844463', 11);
INSERT INTO `street` VALUES (547, '120116054', '120116', '海滨街道', '海滨街道', '117.511383', '38.744862', 12);
INSERT INTO `street` VALUES (548, '120116055', '120116', '港西街道', '港西街道', '117.386711', '38.630547', 10);
INSERT INTO `street` VALUES (549, '120116100', '120116', '新城镇', '新城镇', '117.571381', '38.984459', 30);
INSERT INTO `street` VALUES (550, '120116134', '120116', '大田镇', '大田镇', '117.78051', '39.281174', 8);
INSERT INTO `street` VALUES (551, '120116135', '120116', '杨家泊镇', '杨家泊镇', '117.898941', '39.301006', 34);
INSERT INTO `street` VALUES (552, '120116136', '120116', '茶淀镇', '茶淀镇', '117.805931', '39.262325', 6);
INSERT INTO `street` VALUES (553, '120116156', '120116', '太平镇', '太平镇', '117.336754', '38.617699', 25);
INSERT INTO `street` VALUES (554, '120116157', '120116', '小王庄镇', '小王庄镇', '117.160667', '38.751179', 28);
INSERT INTO `street` VALUES (555, '120116158', '120116', '中塘镇', '中塘镇', '117.385986', '38.866791', 38);
INSERT INTO `street` VALUES (556, '120116400', '120116', '开发区', '开发区', '117.654175', '39.032845', 18);
INSERT INTO `street` VALUES (557, '120116401', '120116', '保税区', '保税区', '117.654175', '39.032845', 1);
INSERT INTO `street` VALUES (558, '120116402', '120116', '天津滨海新区高新技术产业开发区', '天津滨海新区高新技术产业开发区', '117.406723', '39.105232', 26);
INSERT INTO `street` VALUES (559, '120116403', '120116', '东疆保税港区', '东疆保税港区', '117.802994', '39.0121', 9);
INSERT INTO `street` VALUES (560, '120116404', '120116', '中心商务区', '中心商务区', '117.654175', '39.032845', 39);
INSERT INTO `street` VALUES (561, '120116405', '120116', '临港工业区', '临港工业区', '117.716141', '38.954586', 21);
INSERT INTO `street` VALUES (562, '120116406', '120116', '中新天津生态城', '中新天津生态城', '117.654175', '39.032845', 40);
INSERT INTO `street` VALUES (563, '120116407', '120116', '滨海旅游区', '滨海旅游区', '117.62355', '38.846478', 4);
INSERT INTO `street` VALUES (564, '120116408', '120116', '南港工业区', '南港工业区', '117.55835', '38.741711', 22);
INSERT INTO `street` VALUES (565, '120116409', '120116', '临港产业园区一', '临港产业园区一', '117.654175', '39.032845', 20);
INSERT INTO `street` VALUES (566, '120116410', '120116', '临港产业园区二', '临港产业园区二', '117.654175', '39.032845', 19);
INSERT INTO `street` VALUES (567, '120116411', '120116', '北塘经济区', '北塘经济区', '117.71656', '39.1059', 3);
INSERT INTO `street` VALUES (568, '120116412', '120116', '轻纺经济区', '轻纺经济区', '117.654175', '39.032845', 23);
INSERT INTO `street` VALUES (569, '120116413', '120116', '中心渔港经济区', '中心渔港经济区', '117.190804', '39.080887', 41);
INSERT INTO `street` VALUES (570, '120116414', '120116', '海洋高新技术产业园区', '海洋高新技术产业园区', '117.654175', '39.032845', 13);
INSERT INTO `street` VALUES (571, '120221100', '120221', '芦台镇', '芦台镇', '117.822922', '39.328262', 8);
INSERT INTO `street` VALUES (572, '120221102', '120221', '宁河镇', '宁河镇', '117.761894', '39.462841', 13);
INSERT INTO `street` VALUES (573, '120221103', '120221', '苗庄镇', '苗庄镇', '117.817902', '39.429054', 9);
INSERT INTO `street` VALUES (574, '120221104', '120221', '丰台镇', '丰台镇', '117.75824', '39.547295', 6);
INSERT INTO `street` VALUES (575, '120221105', '120221', '岳龙镇', '岳龙镇', '117.871407', '39.572777', 18);
INSERT INTO `street` VALUES (576, '120221106', '120221', '板桥镇', '板桥镇', '117.808525', '39.486877', 1);
INSERT INTO `street` VALUES (577, '120221107', '120221', '潘庄镇', '潘庄镇', '117.475647', '39.345898', 15);
INSERT INTO `street` VALUES (578, '120221109', '120221', '造甲城镇', '造甲城镇', '117.431786', '39.283123', 19);
INSERT INTO `street` VALUES (579, '120221110', '120221', '七里海镇', '七里海镇', '117.67392', '39.309612', 16);
INSERT INTO `street` VALUES (580, '120221111', '120221', '大北涧沽镇', '大北涧沽镇', '117.741379', '39.34153', 4);
INSERT INTO `street` VALUES (581, '120221112', '120221', '东棘坨镇', '东棘坨镇', '117.556824', '39.419926', 5);
INSERT INTO `street` VALUES (582, '120221204', '120221', '北淮淀乡', '北淮淀乡', '117.580994', '39.263107', 2);
INSERT INTO `street` VALUES (583, '120221205', '120221', '俵口乡', '俵口乡', '117.575302', '39.330441', 3);
INSERT INTO `street` VALUES (584, '120221206', '120221', '廉庄子乡', '廉庄子乡', '117.828278', '39.328884', 7);
INSERT INTO `street` VALUES (585, '120221400', '120221', '宁河县贸易开发区', '宁河县贸易开发区', '117.812172', '39.350105', 11);
INSERT INTO `street` VALUES (586, '120221401', '120221', '宁河县经济开发区', '宁河县经济开发区', '117.828278', '39.328884', 10);
INSERT INTO `street` VALUES (587, '120221451', '120221', '宁河县现代产业园区', '宁河县现代产业园区', '117.828278', '39.328884', 12);
INSERT INTO `street` VALUES (588, '120221452', '120221', '天津潘庄工业区', '天津潘庄工业区', '117.828278', '39.328884', 17);
INSERT INTO `street` VALUES (589, '120221500', '120221', '潘庄农场', '潘庄农场', '117.475647', '39.345898', 14);
INSERT INTO `street` VALUES (590, '120223100', '120223', '静海镇', '静海镇', '116.922668', '38.929981', 6);
INSERT INTO `street` VALUES (591, '120223101', '120223', '唐官屯镇', '唐官屯镇', '116.910172', '38.707565', 11);
INSERT INTO `street` VALUES (592, '120223102', '120223', '独流镇', '独流镇', '116.911552', '39.021824', 5);
INSERT INTO `street` VALUES (593, '120223103', '120223', '王口镇', '王口镇', '116.760239', '38.933449', 16);
INSERT INTO `street` VALUES (594, '120223104', '120223', '台头镇', '台头镇', '116.788574', '39.021751', 10);
INSERT INTO `street` VALUES (595, '120223105', '120223', '子牙镇', '子牙镇', '116.775154', '38.822979', 21);
INSERT INTO `street` VALUES (596, '120223106', '120223', '陈官屯镇', '陈官屯镇', '116.913773', '38.8204', 2);
INSERT INTO `street` VALUES (597, '120223107', '120223', '中旺镇', '中旺镇', '117.136665', '38.637775', 20);
INSERT INTO `street` VALUES (598, '120223108', '120223', '大邱庄镇', '大邱庄镇', '117.064461', '38.832352', 4);
INSERT INTO `street` VALUES (599, '120223109', '120223', '蔡公庄镇', '蔡公庄镇', '117.08197', '38.789181', 1);
INSERT INTO `street` VALUES (600, '120223110', '120223', '梁头镇', '梁头镇', '116.855865', '38.934982', 7);
INSERT INTO `street` VALUES (601, '120223111', '120223', '团泊镇', '团泊镇', '117.157249', '38.897057', 15);
INSERT INTO `street` VALUES (602, '120223112', '120223', '双塘镇', '双塘镇', '116.917564', '38.871689', 9);
INSERT INTO `street` VALUES (603, '120223113', '120223', '大丰堆镇', '大丰堆镇', '117.006668', '38.896309', 3);
INSERT INTO `street` VALUES (604, '120223114', '120223', '沿庄镇', '沿庄镇', '116.832977', '38.815994', 19);
INSERT INTO `street` VALUES (605, '120223115', '120223', '西翟庄镇', '西翟庄镇', '117.012177', '38.764965', 17);
INSERT INTO `street` VALUES (606, '120223200', '120223', '良王庄乡', '良王庄乡', '116.975433', '39.025627', 8);
INSERT INTO `street` VALUES (607, '120223201', '120223', '杨成庄乡', '杨成庄乡', '117.052887', '38.945282', 18);
INSERT INTO `street` VALUES (608, '120223400', '120223', '天津静海经济开发区', '天津静海经济开发区', '116.997971', '38.946255', 12);
INSERT INTO `street` VALUES (609, '120223402', '120223', '天津子牙工业园区', '天津子牙工业园区', '116.925301', '38.935673', 13);
INSERT INTO `street` VALUES (610, '120223403', '120223', '团泊新城', '团泊新城', '117.152', '38.889793', 14);
INSERT INTO `street` VALUES (611, '120225001', '120225', '文昌街道', '文昌街道', '117.1157', '40.135002', 17);
INSERT INTO `street` VALUES (612, '120225100', '120225', '渔阳镇', '渔阳镇', '117.407448', '40.045341', 27);
INSERT INTO `street` VALUES (613, '120225101', '120225', '洇溜镇', '洇溜镇', '117.405716', '39.984905', 25);
INSERT INTO `street` VALUES (614, '120225102', '120225', '官庄镇', '官庄镇', '117.310387', '40.062477', 9);
INSERT INTO `street` VALUES (615, '120225103', '120225', '马伸桥镇', '马伸桥镇', '117.604645', '40.084549', 13);
INSERT INTO `street` VALUES (616, '120225104', '120225', '下营镇', '下营镇', '117.450096', '40.183933', 21);
INSERT INTO `street` VALUES (617, '120225105', '120225', '邦均镇', '邦均镇', '117.27491', '39.989838', 2);
INSERT INTO `street` VALUES (618, '120225106', '120225', '别山镇', '别山镇', '117.495071', '39.959335', 3);
INSERT INTO `street` VALUES (619, '120225108', '120225', '尤古庄镇', '尤古庄镇', '117.251961', '39.909248', 26);
INSERT INTO `street` VALUES (620, '120225109', '120225', '上仓镇', '上仓镇', '117.402237', '39.906078', 15);
INSERT INTO `street` VALUES (621, '120225111', '120225', '下仓镇', '下仓镇', '117.423889', '39.789368', 19);
INSERT INTO `street` VALUES (622, '120225112', '120225', '罗庄子镇', '罗庄子镇', '117.42662', '40.138962', 12);
INSERT INTO `street` VALUES (623, '120225113', '120225', '白涧镇', '白涧镇', '117.223175', '39.998524', 1);
INSERT INTO `street` VALUES (624, '120225114', '120225', '五百户镇', '五百户镇', '117.615334', '40.000732', 18);
INSERT INTO `street` VALUES (625, '120225115', '120225', '侯家营镇', '侯家营镇', '117.275749', '39.849472', 10);
INSERT INTO `street` VALUES (626, '120225116', '120225', '桑梓镇', '桑梓镇', '117.17189', '39.909866', 14);
INSERT INTO `street` VALUES (627, '120225117', '120225', '东施古镇', '东施古镇', '117.329185', '39.886726', 7);
INSERT INTO `street` VALUES (628, '120225118', '120225', '下窝头镇', '下窝头镇', '117.405785', '39.864048', 20);
INSERT INTO `street` VALUES (629, '120225119', '120225', '杨津庄镇', '杨津庄镇', '117.432381', '39.86795', 24);
INSERT INTO `street` VALUES (630, '120225120', '120225', '出头岭镇', '出头岭镇', '117.677017', '40.075241', 5);
INSERT INTO `street` VALUES (631, '120225121', '120225', '西龙虎峪镇', '西龙虎峪镇', '117.722908', '40.002163', 22);
INSERT INTO `street` VALUES (632, '120225122', '120225', '穿芳峪镇', '穿芳峪镇', '117.407448', '40.045341', 4);
INSERT INTO `street` VALUES (633, '120225123', '120225', '东二营镇', '东二营镇', '117.407448', '40.045341', 6);
INSERT INTO `street` VALUES (634, '120225124', '120225', '许家台镇', '许家台镇', '117.407448', '40.045341', 23);
INSERT INTO `street` VALUES (635, '120225125', '120225', '礼明庄镇', '礼明庄镇', '117.407448', '40.045341', 11);
INSERT INTO `street` VALUES (636, '120225126', '120225', '东赵各庄镇', '东赵各庄镇', '117.407448', '40.045341', 8);
INSERT INTO `street` VALUES (637, '120225203', '120225', '孙各庄乡', '孙各庄乡', '117.597687', '40.13641', 16);
INSERT INTO `street` VALUES (10009, '310101002', '310101', '南京东路街道', '南京东路街道', '121.490318', '31.222771', 5);
INSERT INTO `street` VALUES (10010, '310101013', '310101', '外滩街道', '外滩街道', '121.482338', '31.238417', 7);
INSERT INTO `street` VALUES (10011, '310101015', '310101', '半淞园路街道', '半淞园路街道', '121.490318', '31.222771', 1);
INSERT INTO `street` VALUES (10012, '310101017', '310101', '小东门街道', '小东门街道', '121.50032', '31.223551', 9);
INSERT INTO `street` VALUES (10013, '310101018', '310101', '豫园街道', '豫园街道', '121.493599', '31.226196', 10);
INSERT INTO `street` VALUES (10014, '310101019', '310101', '老西门街道', '老西门街道', '121.488976', '31.217466', 4);
INSERT INTO `street` VALUES (10015, '310101020', '310101', '五里桥街道', '五里桥街道', '121.479126', '31.19832', 8);
INSERT INTO `street` VALUES (10016, '310101021', '310101', '打浦桥街道', '打浦桥街道', '121.473824', '31.204077', 2);
INSERT INTO `street` VALUES (10017, '310101022', '310101', '淮海中路街道', '淮海中路街道', '121.490318', '31.222771', 3);
INSERT INTO `street` VALUES (10018, '310101023', '310101', '瑞金二路街道', '瑞金二路街道', '121.490318', '31.222771', 6);
INSERT INTO `street` VALUES (10019, '310104003', '310104', '天平路街道', '天平路街道', '121.437523', '31.179974', 11);
INSERT INTO `street` VALUES (10020, '310104004', '310104', '湖南路街道', '湖南路街道', '121.437523', '31.179974', 6);
INSERT INTO `street` VALUES (10021, '310104007', '310104', '斜土路街道', '斜土路街道', '121.437523', '31.179974', 12);
INSERT INTO `street` VALUES (10022, '310104008', '310104', '枫林路街道', '枫林路街道', '121.437523', '31.179974', 3);
INSERT INTO `street` VALUES (10023, '310104010', '310104', '长桥街道', '长桥街道', '121.440552', '31.137693', 14);
INSERT INTO `street` VALUES (10024, '310104011', '310104', '田林街道', '田林街道', '121.42527', '31.174652', 10);
INSERT INTO `street` VALUES (10025, '310104012', '310104', '虹梅路街道', '虹梅路街道', '121.437523', '31.179974', 4);
INSERT INTO `street` VALUES (10026, '310104013', '310104', '康健新村街道', '康健新村街道', '121.422668', '31.155811', 7);
INSERT INTO `street` VALUES (10027, '310104014', '310104', '徐家汇街道', '徐家汇街道', '121.435333', '31.188271', 13);
INSERT INTO `street` VALUES (10028, '310104015', '310104', '凌云路街道', '凌云路街道', '121.437523', '31.179974', 8);
INSERT INTO `street` VALUES (10029, '310104016', '310104', '龙华街道', '龙华街道', '121.45253', '31.170408', 9);
INSERT INTO `street` VALUES (10030, '310104017', '310104', '漕河泾街道', '漕河泾街道', '121.430244', '31.166271', 1);
INSERT INTO `street` VALUES (10031, '310104103', '310104', '华泾镇', '华泾镇', '121.456596', '31.117868', 5);
INSERT INTO `street` VALUES (10032, '310104501', '310104', '漕河泾新兴技术开发区', '漕河泾新兴技术开发区', '121.430244', '31.166271', 2);
INSERT INTO `street` VALUES (10033, '310105001', '310105', '华阳路街道', '华阳路街道', '121.422203', '31.218122', 4);
INSERT INTO `street` VALUES (10034, '310105002', '310105', '江苏路街道', '江苏路街道', '121.422203', '31.218122', 5);
INSERT INTO `street` VALUES (10035, '310105004', '310105', '新华路街道', '新华路街道', '121.422203', '31.218122', 8);
INSERT INTO `street` VALUES (10036, '310105005', '310105', '周家桥街道', '周家桥街道', '121.408104', '31.217493', 10);
INSERT INTO `street` VALUES (10037, '310105006', '310105', '天山路街道', '天山路街道', '121.422203', '31.218122', 6);
INSERT INTO `street` VALUES (10038, '310105008', '310105', '仙霞新村街道', '仙霞新村街道', '121.394585', '31.206863', 7);
INSERT INTO `street` VALUES (10039, '310105009', '310105', '虹桥街道', '虹桥街道', '121.41066', '31.196987', 3);
INSERT INTO `street` VALUES (10040, '310105010', '310105', '程家桥街道', '程家桥街道', '121.368896', '31.193672', 2);
INSERT INTO `street` VALUES (10041, '310105011', '310105', '北新泾街道', '北新泾街道', '121.374344', '31.218588', 1);
INSERT INTO `street` VALUES (10042, '310105102', '310105', '新泾镇', '新泾镇', '121.372551', '31.212299', 9);
INSERT INTO `street` VALUES (10043, '310106006', '310106', '江宁路街道', '江宁路街道', '121.448227', '31.229004', 2);
INSERT INTO `street` VALUES (10044, '310106011', '310106', '石门二路街道', '石门二路街道', '121.448227', '31.229004', 5);
INSERT INTO `street` VALUES (10045, '310106012', '310106', '南京西路街道', '南京西路街道', '121.448227', '31.229004', 4);
INSERT INTO `street` VALUES (10046, '310106013', '310106', '静安寺街道', '静安寺街道', '121.446564', '31.220114', 3);
INSERT INTO `street` VALUES (10047, '310106014', '310106', '曹家渡街道', '曹家渡街道', '121.432487', '31.226091', 1);
INSERT INTO `street` VALUES (10048, '310107005', '310107', '曹杨新村街道', '曹杨新村街道', '121.407524', '31.237305', 1);
INSERT INTO `street` VALUES (10049, '310107014', '310107', '长风新村街道', '长风新村街道', '121.399544', '31.232462', 6);
INSERT INTO `street` VALUES (10050, '310107015', '310107', '长寿路街道', '长寿路街道', '121.392502', '31.241701', 7);
INSERT INTO `street` VALUES (10051, '310107016', '310107', '甘泉路街道', '甘泉路街道', '121.392502', '31.241701', 2);
INSERT INTO `street` VALUES (10052, '310107017', '310107', '石泉路街道', '石泉路街道', '121.392502', '31.241701', 3);
INSERT INTO `street` VALUES (10053, '310107020', '310107', '宜川路街道', '宜川路街道', '121.392502', '31.241701', 5);
INSERT INTO `street` VALUES (10054, '310107101', '310107', '真如镇', '真如镇', '121.401268', '31.25696', 9);
INSERT INTO `street` VALUES (10055, '310107102', '310107', '长征镇', '长征镇', '121.373306', '31.2379', 8);
INSERT INTO `street` VALUES (10056, '310107103', '310107', '桃浦镇', '桃浦镇', '121.36348', '31.27898', 4);
INSERT INTO `street` VALUES (10057, '310108001', '310108', '天目西路街道', '天目西路街道', '121.465691', '31.25318', 8);
INSERT INTO `street` VALUES (10058, '310108006', '310108', '北站街道', '北站街道', '121.471718', '31.246944', 2);
INSERT INTO `street` VALUES (10059, '310108007', '310108', '宝山路街道', '宝山路街道', '121.465691', '31.25318', 1);
INSERT INTO `street` VALUES (10060, '310108012', '310108', '共和新路街道', '共和新路街道', '121.465691', '31.25318', 4);
INSERT INTO `street` VALUES (10061, '310108013', '310108', '大宁路街道', '大宁路街道', '121.465691', '31.25318', 3);
INSERT INTO `street` VALUES (10062, '310108014', '310108', '彭浦新村街道', '彭浦新村街道', '121.445381', '31.312256', 6);
INSERT INTO `street` VALUES (10063, '310108015', '310108', '临汾路街道', '临汾路街道', '121.465691', '31.25318', 5);
INSERT INTO `street` VALUES (10064, '310108016', '310108', '芷江西路街道', '芷江西路街道', '121.465691', '31.25318', 9);
INSERT INTO `street` VALUES (10065, '310108101', '310108', '彭浦镇', '彭浦镇', '121.44706', '31.281563', 7);
INSERT INTO `street` VALUES (10066, '310109009', '310109', '欧阳路街道', '欧阳路街道', '121.491829', '31.260969', 5);
INSERT INTO `street` VALUES (10067, '310109010', '310109', '曲阳路街道', '曲阳路街道', '121.491829', '31.260969', 6);
INSERT INTO `street` VALUES (10068, '310109011', '310109', '广中路街道', '广中路街道', '121.491829', '31.260969', 1);
INSERT INTO `street` VALUES (10069, '310109014', '310109', '嘉兴路街道', '嘉兴路街道', '121.491829', '31.260969', 3);
INSERT INTO `street` VALUES (10070, '310109016', '310109', '凉城新村街道', '凉城新村街道', '121.471458', '31.295122', 4);
INSERT INTO `street` VALUES (10071, '310109017', '310109', '四川北路街道', '四川北路街道', '121.491829', '31.260969', 7);
INSERT INTO `street` VALUES (10072, '310109018', '310109', '提篮桥街道', '提篮桥街道', '121.500511', '31.25222', 8);
INSERT INTO `street` VALUES (10073, '310109019', '310109', '江湾镇街道', '江湾镇街道', '121.491829', '31.260969', 2);
INSERT INTO `street` VALUES (10074, '310110001', '310110', '定海路街道', '定海路街道', '121.522797', '31.270756', 2);
INSERT INTO `street` VALUES (10075, '310110006', '310110', '平凉路街道', '平凉路街道', '121.522797', '31.270756', 5);
INSERT INTO `street` VALUES (10076, '310110008', '310110', '江浦路街道', '江浦路街道', '121.522797', '31.270756', 3);
INSERT INTO `street` VALUES (10077, '310110009', '310110', '四平路街道', '四平路街道', '121.522797', '31.270756', 6);
INSERT INTO `street` VALUES (10078, '310110012', '310110', '控江路街道', '控江路街道', '121.522797', '31.270756', 4);
INSERT INTO `street` VALUES (10079, '310110013', '310110', '长白新村街道', '长白新村街道', '121.544571', '31.287825', 12);
INSERT INTO `street` VALUES (10080, '310110015', '310110', '延吉新村街道', '延吉新村街道', '121.536903', '31.288689', 10);
INSERT INTO `street` VALUES (10081, '310110016', '310110', '殷行街道', '殷行街道', '121.537712', '31.32387', 11);
INSERT INTO `street` VALUES (10082, '310110018', '310110', '大桥街道', '大桥街道', '121.528267', '31.267912', 1);
INSERT INTO `street` VALUES (10083, '310110019', '310110', '五角场街道', '五角场街道', '121.52063', '31.305433', 7);
INSERT INTO `street` VALUES (10084, '310110020', '310110', '新江湾城街道', '新江湾城街道', '121.515884', '31.327175', 9);
INSERT INTO `street` VALUES (10085, '310110101', '310110', '五角场镇', '五角场镇', '121.520546', '31.308525', 8);
INSERT INTO `street` VALUES (10086, '310112001', '310112', '江川路街道', '江川路街道', '121.375969', '31.111658', 4);
INSERT INTO `street` VALUES (10087, '310112006', '310112', '古美街道', '古美街道', '121.404457', '31.145004', 1);
INSERT INTO `street` VALUES (10088, '310112008', '310112', '新虹街道', '新虹街道', '121.375969', '31.111658', 10);
INSERT INTO `street` VALUES (10089, '310112101', '310112', '莘庄镇', '莘庄镇', '121.370384', '31.121258', 12);
INSERT INTO `street` VALUES (10090, '310112102', '310112', '七宝镇', '七宝镇', '121.351372', '31.157658', 8);
INSERT INTO `street` VALUES (10091, '310112103', '310112', '颛桥镇', '颛桥镇', '121.40081', '31.065714', 13);
INSERT INTO `street` VALUES (10092, '310112106', '310112', '华漕镇', '华漕镇', '121.293549', '31.20775', 3);
INSERT INTO `street` VALUES (10093, '310112107', '310112', '虹桥镇', '虹桥镇', '121.384613', '31.177397', 2);
INSERT INTO `street` VALUES (10094, '310112108', '310112', '梅陇镇', '梅陇镇', '121.426773', '31.10228', 6);
INSERT INTO `street` VALUES (10095, '310112110', '310112', '吴泾镇', '吴泾镇', '121.464554', '31.039946', 9);
INSERT INTO `street` VALUES (10096, '310112112', '310112', '马桥镇', '马桥镇', '121.36866', '31.030396', 5);
INSERT INTO `street` VALUES (10097, '310112114', '310112', '浦江镇', '浦江镇', '121.506172', '31.088524', 7);
INSERT INTO `street` VALUES (10098, '310112501', '310112', '莘庄工业区', '莘庄工业区', '121.394676', '31.07951', 11);
INSERT INTO `street` VALUES (10099, '310113003', '310113', '友谊路街道', '友谊路街道', '121.489937', '31.398895', 11);
INSERT INTO `street` VALUES (10100, '310113007', '310113', '吴淞街道', '吴淞街道', '121.493561', '31.372606', 9);
INSERT INTO `street` VALUES (10101, '310113008', '310113', '张庙街道', '张庙街道', '121.489937', '31.398895', 13);
INSERT INTO `street` VALUES (10102, '310113101', '310113', '罗店镇', '罗店镇', '121.346626', '31.415251', 5);
INSERT INTO `street` VALUES (10103, '310113102', '310113', '大场镇', '大场镇', '121.417068', '31.286877', 2);
INSERT INTO `street` VALUES (10104, '310113103', '310113', '杨行镇', '杨行镇', '121.438293', '31.364479', 10);
INSERT INTO `street` VALUES (10105, '310113104', '310113', '月浦镇', '月浦镇', '121.421677', '31.420567', 12);
INSERT INTO `street` VALUES (10106, '310113106', '310113', '罗泾镇', '罗泾镇', '121.327942', '31.472258', 6);
INSERT INTO `street` VALUES (10107, '310113109', '310113', '顾村镇', '顾村镇', '121.40699', '31.349552', 4);
INSERT INTO `street` VALUES (10108, '310113111', '310113', '高境镇', '高境镇', '121.482574', '31.32077', 3);
INSERT INTO `street` VALUES (10109, '310113112', '310113', '庙行镇', '庙行镇', '121.449684', '31.319788', 7);
INSERT INTO `street` VALUES (10110, '310113113', '310113', '淞南镇', '淞南镇', '121.489937', '31.398895', 8);
INSERT INTO `street` VALUES (10111, '310113501', '310113', '宝山城市工业园区', '宝山城市工业园区', '121.354095', '31.317307', 1);
INSERT INTO `street` VALUES (10112, '310114001', '310114', '新成路街道', '新成路街道', '121.250336', '31.383524', 10);
INSERT INTO `street` VALUES (10113, '310114002', '310114', '真新街道', '真新街道', '121.250336', '31.383524', 12);
INSERT INTO `street` VALUES (10114, '310114003', '310114', '菊园新区管委会', '菊园新区管委会', '121.245598', '31.392593', 6);
INSERT INTO `street` VALUES (10115, '310114004', '310114', '嘉定镇街道', '嘉定镇街道', '121.23774', '31.37241', 4);
INSERT INTO `street` VALUES (10116, '310114102', '310114', '南翔镇', '南翔镇', '121.320824', '31.293978', 8);
INSERT INTO `street` VALUES (10117, '310114103', '310114', '安亭镇', '安亭镇', '121.163589', '31.294075', 1);
INSERT INTO `street` VALUES (10118, '310114106', '310114', '马陆镇', '马陆镇', '121.283539', '31.332663', 7);
INSERT INTO `street` VALUES (10119, '310114109', '310114', '徐行镇', '徐行镇', '121.274178', '31.415682', 11);
INSERT INTO `street` VALUES (10120, '310114111', '310114', '华亭镇', '华亭镇', '121.240433', '31.462957', 2);
INSERT INTO `street` VALUES (10121, '310114114', '310114', '外冈镇', '外冈镇', '121.175293', '31.361231', 9);
INSERT INTO `street` VALUES (10122, '310114118', '310114', '江桥镇', '江桥镇', '121.341606', '31.254568', 5);
INSERT INTO `street` VALUES (10123, '310114501', '310114', '嘉定工业区', '嘉定工业区', '121.415047', '31.239893', 3);
INSERT INTO `street` VALUES (10124, '310115004', '310115', '潍坊新村街道', '潍坊新村街道', '121.523079', '31.22114', 34);
INSERT INTO `street` VALUES (10125, '310115005', '310115', '陆家嘴街道', '陆家嘴街道', '121.525627', '31.237213', 22);
INSERT INTO `street` VALUES (10126, '310115007', '310115', '周家渡街道', '周家渡街道', '121.498947', '31.175034', 40);
INSERT INTO `street` VALUES (10127, '310115008', '310115', '塘桥街道', '塘桥街道', '121.527573', '31.2097', 30);
INSERT INTO `street` VALUES (10128, '310115009', '310115', '上钢新村街道', '上钢新村街道', '121.491486', '31.176172', 28);
INSERT INTO `street` VALUES (10129, '310115010', '310115', '南码头路街道', '南码头路街道', '121.567703', '31.245943', 24);
INSERT INTO `street` VALUES (10130, '310115011', '310115', '沪东新村街道', '沪东新村街道', '121.58271', '31.268007', 14);
INSERT INTO `street` VALUES (10131, '310115012', '310115', '金杨新村街道', '金杨新村街道', '121.556557', '31.244419', 18);
INSERT INTO `street` VALUES (10132, '310115013', '310115', '洋泾街道', '洋泾街道', '121.546852', '31.236193', 37);
INSERT INTO `street` VALUES (10133, '310115014', '310115', '浦兴路街道', '浦兴路街道', '121.567703', '31.245943', 26);
INSERT INTO `street` VALUES (10134, '310115015', '310115', '东明路街道', '东明路街道', '121.567703', '31.245943', 7);
INSERT INTO `street` VALUES (10135, '310115016', '310115', '花木街道', '花木街道', '121.547737', '31.206615', 13);
INSERT INTO `street` VALUES (10136, '310115103', '310115', '川沙新镇', '川沙新镇', '121.696243', '31.192808', 4);
INSERT INTO `street` VALUES (10137, '310115104', '310115', '高桥镇', '高桥镇', '121.575485', '31.341562', 9);
INSERT INTO `street` VALUES (10138, '310115105', '310115', '北蔡镇', '北蔡镇', '121.554543', '31.181868', 1);
INSERT INTO `street` VALUES (10139, '310115110', '310115', '合庆镇', '合庆镇', '121.723709', '31.236879', 12);
INSERT INTO `street` VALUES (10140, '310115114', '310115', '唐镇', '唐镇', '121.656029', '31.208324', 31);
INSERT INTO `street` VALUES (10141, '310115117', '310115', '曹路镇', '曹路镇', '121.666977', '31.278399', 2);
INSERT INTO `street` VALUES (10142, '310115120', '310115', '金桥镇', '金桥镇', '121.611244', '31.266132', 17);
INSERT INTO `street` VALUES (10143, '310115121', '310115', '高行镇', '高行镇', '121.606628', '31.29295', 10);
INSERT INTO `street` VALUES (10144, '310115123', '310115', '高东镇', '高东镇', '121.62278', '31.327013', 8);
INSERT INTO `street` VALUES (10145, '310115125', '310115', '张江镇', '张江镇', '121.614288', '31.205288', 39);
INSERT INTO `street` VALUES (10146, '310115130', '310115', '三林镇', '三林镇', '121.502403', '31.145086', 27);
INSERT INTO `street` VALUES (10147, '310115131', '310115', '惠南镇', '惠南镇', '121.749481', '31.048182', 15);
INSERT INTO `street` VALUES (10148, '310115132', '310115', '周浦镇', '周浦镇', '121.574951', '31.114302', 41);
INSERT INTO `street` VALUES (10149, '310115133', '310115', '新场镇', '新场镇', '121.653458', '31.026157', 35);
INSERT INTO `street` VALUES (10150, '310115134', '310115', '大团镇', '大团镇', '121.747787', '30.970858', 5);
INSERT INTO `street` VALUES (10151, '310115136', '310115', '康桥镇', '康桥镇', '121.577629', '31.123646', 19);
INSERT INTO `street` VALUES (10152, '310115137', '310115', '航头镇', '航头镇', '121.587212', '31.033009', 11);
INSERT INTO `street` VALUES (10153, '310115139', '310115', '祝桥镇', '祝桥镇', '121.757111', '31.115215', 42);
INSERT INTO `street` VALUES (10154, '310115140', '310115', '泥城镇', '泥城镇', '121.830627', '30.903946', 25);
INSERT INTO `street` VALUES (10155, '310115141', '310115', '宣桥镇', '宣桥镇', '121.695076', '31.035667', 36);
INSERT INTO `street` VALUES (10156, '310115142', '310115', '书院镇', '书院镇', '121.871094', '30.92495', 29);
INSERT INTO `street` VALUES (10157, '310115143', '310115', '万祥镇', '万祥镇', '121.815536', '30.973009', 33);
INSERT INTO `street` VALUES (10158, '310115144', '310115', '老港镇', '老港镇', '121.839851', '31.039539', 20);
INSERT INTO `street` VALUES (10159, '310115145', '310115', '南汇新城镇', '南汇新城镇', '121.567703', '31.245943', 23);
INSERT INTO `street` VALUES (10160, '310115401', '310115', '芦潮港农场', '芦潮港农场', '121.846527', '30.856661', 21);
INSERT INTO `street` VALUES (10161, '310115402', '310115', '东海农场', '东海农场', '121.567703', '31.245943', 6);
INSERT INTO `street` VALUES (10162, '310115403', '310115', '朝阳农场', '朝阳农场', '121.734543', '31.250696', 3);
INSERT INTO `street` VALUES (10163, '310115501', '310115', '外高桥保税区', '外高桥保税区', '121.567703', '31.245943', 32);
INSERT INTO `street` VALUES (10164, '310115502', '310115', '金桥经济技术开发区', '金桥经济技术开发区', '121.597679', '31.24901', 16);
INSERT INTO `street` VALUES (10165, '310115503', '310115', '张江高科技园区', '张江高科技园区', '121.590218', '31.204781', 38);
INSERT INTO `street` VALUES (10166, '310116001', '310116', '石化街道', '石化街道', '121.334305', '30.716763', 8);
INSERT INTO `street` VALUES (10167, '310116101', '310116', '朱泾镇', '朱泾镇', '121.163918', '30.900454', 11);
INSERT INTO `street` VALUES (10168, '310116102', '310116', '枫泾镇', '枫泾镇', '121.010353', '30.888329', 2);
INSERT INTO `street` VALUES (10169, '310116103', '310116', '张堰镇', '张堰镇', '121.28894', '30.802692', 10);
INSERT INTO `street` VALUES (10170, '310116104', '310116', '亭林镇', '亭林镇', '121.313652', '30.882734', 9);
INSERT INTO `street` VALUES (10171, '310116105', '310116', '吕巷镇', '吕巷镇', '121.182846', '30.831846', 6);
INSERT INTO `street` VALUES (10172, '310116107', '310116', '廊下镇', '廊下镇', '121.192909', '30.790003', 5);
INSERT INTO `street` VALUES (10173, '310116109', '310116', '金山卫镇', '金山卫镇', '121.317917', '30.724684', 4);
INSERT INTO `street` VALUES (10174, '310116112', '310116', '漕泾镇', '漕泾镇', '121.410889', '30.79405', 1);
INSERT INTO `street` VALUES (10175, '310116113', '310116', '山阳镇', '山阳镇', '121.356613', '30.761057', 7);
INSERT INTO `street` VALUES (10176, '310116503', '310116', '金山工业区', '金山工业区', '121.348152', '30.840345', 3);
INSERT INTO `street` VALUES (10177, '310117001', '310117', '岳阳街道', '岳阳街道', '121.22715', '31.008469', 17);
INSERT INTO `street` VALUES (10178, '310117002', '310117', '永丰街道', '永丰街道', '121.215935', '31.001966', 16);
INSERT INTO `street` VALUES (10179, '310117003', '310117', '方松街道', '方松街道', '121.19603', '31.061396', 3);
INSERT INTO `street` VALUES (10180, '310117004', '310117', '中山街道', '中山街道', '121.244446', '31.025843', 18);
INSERT INTO `street` VALUES (10181, '310117102', '310117', '泗泾镇', '泗泾镇', '121.271347', '31.118164', 10);
INSERT INTO `street` VALUES (10182, '310117103', '310117', '佘山镇', '佘山镇', '121.197456', '31.091818', 8);
INSERT INTO `street` VALUES (10183, '310117104', '310117', '车墩镇', '车墩镇', '121.315086', '31.014994', 1);
INSERT INTO `street` VALUES (10184, '310117105', '310117', '新桥镇', '新桥镇', '121.31572', '31.058765', 14);
INSERT INTO `street` VALUES (10185, '310117106', '310117', '洞泾镇', '洞泾镇', '121.268944', '31.081709', 2);
INSERT INTO `street` VALUES (10186, '310117107', '310117', '九亭镇', '九亭镇', '121.328941', '31.131672', 4);
INSERT INTO `street` VALUES (10187, '310117109', '310117', '泖港镇', '泖港镇', '121.213539', '30.933462', 5);
INSERT INTO `street` VALUES (10188, '310117116', '310117', '石湖荡镇', '石湖荡镇', '121.119415', '30.984434', 9);
INSERT INTO `street` VALUES (10189, '310117117', '310117', '新浜镇', '新浜镇', '121.067818', '30.933969', 13);
INSERT INTO `street` VALUES (10190, '310117120', '310117', '叶榭镇', '叶榭镇', '121.321342', '30.942787', 15);
INSERT INTO `street` VALUES (10191, '310117121', '310117', '小昆山镇', '小昆山镇', '121.141556', '31.033819', 12);
INSERT INTO `street` VALUES (10192, '310117501', '310117', '松江工业区', '松江工业区', '121.304817', '30.996843', 11);
INSERT INTO `street` VALUES (10193, '310117504', '310117', '佘山度假区', '佘山度假区', '121.197456', '31.091818', 7);
INSERT INTO `street` VALUES (10194, '310117507', '310117', '上海松江出口加工区', '上海松江出口加工区', '121.299438', '31.021694', 6);
INSERT INTO `street` VALUES (10195, '310118001', '310118', '夏阳街道', '夏阳街道', '121.125412', '31.149097', 6);
INSERT INTO `street` VALUES (10196, '310118002', '310118', '盈浦街道', '盈浦街道', '121.114479', '31.145941', 8);
INSERT INTO `street` VALUES (10197, '310118003', '310118', '香花桥街道', '香花桥街道', '121.123985', '31.170988', 5);
INSERT INTO `street` VALUES (10198, '310118102', '310118', '朱家角镇', '朱家角镇', '121.056297', '31.10969', 11);
INSERT INTO `street` VALUES (10199, '310118103', '310118', '练塘镇', '练塘镇', '121.045563', '31.006893', 4);
INSERT INTO `street` VALUES (10200, '310118104', '310118', '金泽镇', '金泽镇', '120.921722', '31.036219', 3);
INSERT INTO `street` VALUES (10201, '310118105', '310118', '赵巷镇', '赵巷镇', '121.196136', '31.149019', 9);
INSERT INTO `street` VALUES (10202, '310118106', '310118', '徐泾镇', '徐泾镇', '121.272713', '31.172737', 7);
INSERT INTO `street` VALUES (10203, '310118107', '310118', '华新镇', '华新镇', '121.22728', '31.245512', 2);
INSERT INTO `street` VALUES (10204, '310118109', '310118', '重固镇', '重固镇', '121.18309', '31.199842', 10);
INSERT INTO `street` VALUES (10205, '310118110', '310118', '白鹤镇', '白鹤镇', '121.143166', '31.259146', 1);
INSERT INTO `street` VALUES (10206, '310120101', '310120', '南桥镇', '南桥镇', '121.458862', '30.903461', 6);
INSERT INTO `street` VALUES (10207, '310120102', '310120', '奉城镇', '奉城镇', '121.648987', '30.915899', 1);
INSERT INTO `street` VALUES (10208, '310120104', '310120', '庄行镇', '庄行镇', '121.397507', '30.901573', 12);
INSERT INTO `street` VALUES (10209, '310120106', '310120', '金汇镇', '金汇镇', '121.50132', '30.988874', 5);
INSERT INTO `street` VALUES (10210, '310120109', '310120', '四团镇', '四团镇', '121.7229', '30.939274', 10);
INSERT INTO `street` VALUES (10211, '310120111', '310120', '青村镇', '青村镇', '121.581551', '30.923552', 7);
INSERT INTO `street` VALUES (10212, '310120118', '310120', '柘林镇', '柘林镇', '121.473778', '30.829977', 11);
INSERT INTO `street` VALUES (10213, '310120123', '310120', '海湾镇', '海湾镇', '121.567459', '30.860558', 3);
INSERT INTO `street` VALUES (10214, '310120501', '310120', '奉浦社区', '奉浦社区', '121.458473', '30.912346', 2);
INSERT INTO `street` VALUES (10215, '310120503', '310120', '上海市奉贤区海湾旅游区', '上海市奉贤区海湾旅游区', '121.567459', '30.860558', 9);
INSERT INTO `street` VALUES (10216, '310120504', '310120', '金海社区', '金海社区', '121.458473', '30.912346', 4);
INSERT INTO `street` VALUES (10217, '310120505', '310120', '上海海港综合经济开发区', '上海海港综合经济开发区', '121.458473', '30.912346', 8);
INSERT INTO `street` VALUES (10218, '310230101', '310230', '城桥镇', '城桥镇', '121.398102', '31.628162', 2);
INSERT INTO `street` VALUES (10219, '310230102', '310230', '堡镇', '堡镇', '121.618416', '31.536646', 1);
INSERT INTO `street` VALUES (10220, '310230103', '310230', '新河镇', '新河镇', '121.524483', '31.581652', 19);
INSERT INTO `street` VALUES (10221, '310230104', '310230', '庙镇', '庙镇', '121.349709', '31.712858', 11);
INSERT INTO `street` VALUES (10222, '310230106', '310230', '竖新镇', '竖新镇', '121.60376', '31.61471', 15);
INSERT INTO `street` VALUES (10223, '310230107', '310230', '向化镇', '向化镇', '121.723526', '31.520567', 16);
INSERT INTO `street` VALUES (10224, '310230109', '310230', '三星镇', '三星镇', '121.287994', '31.743271', 13);
INSERT INTO `street` VALUES (10225, '310230113', '310230', '港沿镇', '港沿镇', '121.656494', '31.587828', 7);
INSERT INTO `street` VALUES (10226, '310230114', '310230', '中兴镇', '中兴镇', '121.758141', '31.524', 21);
INSERT INTO `street` VALUES (10227, '310230115', '310230', '陈家镇', '陈家镇', '121.832565', '31.526228', 3);
INSERT INTO `street` VALUES (10228, '310230116', '310230', '绿华镇', '绿华镇', '121.220535', '31.762451', 10);
INSERT INTO `street` VALUES (10229, '310230118', '310230', '港西镇', '港西镇', '121.415779', '31.687752', 6);
INSERT INTO `street` VALUES (10230, '310230119', '310230', '建设镇', '建设镇', '121.455666', '31.654594', 9);
INSERT INTO `street` VALUES (10231, '310230121', '310230', '新海镇', '新海镇', '121.397514', '31.626945', 18);
INSERT INTO `street` VALUES (10232, '310230122', '310230', '东平镇', '东平镇', '121.397514', '31.626945', 5);
INSERT INTO `street` VALUES (10233, '310230123', '310230', '长兴镇', '长兴镇', '121.397514', '31.626945', 20);
INSERT INTO `street` VALUES (10234, '310230201', '310230', '新村乡', '新村乡', '121.332115', '31.829382', 17);
INSERT INTO `street` VALUES (10235, '310230203', '310230', '横沙乡', '横沙乡', '121.845093', '31.338011', 8);
INSERT INTO `street` VALUES (10236, '310230409', '310230', '前卫农场', '前卫农场', '121.511551', '31.718769', 12);
INSERT INTO `street` VALUES (10237, '310230410', '310230', '东平林场', '东平林场', '121.49176', '31.607515', 4);
INSERT INTO `street` VALUES (10238, '310230501', '310230', '上实现代农业园区', '上实现代农业园区', '121.397514', '31.626945', 14);
INSERT INTO `street` VALUES (28802, '500101001', '500101', '高笋塘街道', '高笋塘街道', '108.379372', '30.81184', 13);
INSERT INTO `street` VALUES (28803, '500101017', '500101', '太白街道', '太白街道', '108.380249', '30.807808', 32);
INSERT INTO `street` VALUES (28804, '500101018', '500101', '牌楼街道', '牌楼街道', '108.388283', '30.790768', 25);
INSERT INTO `street` VALUES (28805, '500101019', '500101', '双河口街道', '双河口街道', '108.386421', '30.755936', 29);
INSERT INTO `street` VALUES (28806, '500101020', '500101', '龙都街道', '龙都街道', '108.380249', '30.807808', 21);
INSERT INTO `street` VALUES (28807, '500101021', '500101', '周家坝街道', '周家坝街道', '108.380249', '30.807808', 50);
INSERT INTO `street` VALUES (28808, '500101022', '500101', '沙河街道', '沙河街道', '108.355621', '30.82295', 28);
INSERT INTO `street` VALUES (28809, '500101023', '500101', '钟鼓楼街道', '钟鼓楼街道', '108.388832', '30.816065', 49);
INSERT INTO `street` VALUES (28810, '500101024', '500101', '百安坝街道', '百安坝街道', '108.442863', '30.766911', 1);
INSERT INTO `street` VALUES (28811, '500101025', '500101', '五桥街道', '五桥街道', '108.448875', '30.770807', 37);
INSERT INTO `street` VALUES (28812, '500101026', '500101', '陈家坝街道', '陈家坝街道', '108.397697', '30.807764', 4);
INSERT INTO `street` VALUES (28813, '500101109', '500101', '小周镇', '小周镇', '108.524155', '30.936726', 39);
INSERT INTO `street` VALUES (28814, '500101110', '500101', '大周镇', '大周镇', '108.502174', '30.893711', 7);
INSERT INTO `street` VALUES (28815, '500101123', '500101', '新乡镇', '新乡镇', '108.278152', '30.496927', 42);
INSERT INTO `street` VALUES (28816, '500101132', '500101', '孙家镇', '孙家镇', '108.380249', '30.807808', 30);
INSERT INTO `street` VALUES (28817, '500101134', '500101', '高峰镇', '高峰镇', '108.347961', '30.705585', 11);
INSERT INTO `street` VALUES (28818, '500101135', '500101', '龙沙镇', '龙沙镇', '108.23777', '30.634315', 23);
INSERT INTO `street` VALUES (28819, '500101136', '500101', '响水镇', '响水镇', '108.20121', '30.650387', 38);
INSERT INTO `street` VALUES (28820, '500101137', '500101', '武陵镇', '武陵镇', '108.250137', '30.513025', 36);
INSERT INTO `street` VALUES (28821, '500101138', '500101', '瀼渡镇', '瀼渡镇', '108.315086', '30.597092', 27);
INSERT INTO `street` VALUES (28822, '500101139', '500101', '甘宁镇', '甘宁镇', '108.380249', '30.807808', 10);
INSERT INTO `street` VALUES (28823, '500101140', '500101', '天城镇', '天城镇', '108.379173', '30.864353', 34);
INSERT INTO `street` VALUES (28824, '500101141', '500101', '熊家镇', '熊家镇', '108.441666', '30.898123', 43);
INSERT INTO `street` VALUES (28825, '500101142', '500101', '高梁镇', '高梁镇', '108.2873', '30.837189', 12);
INSERT INTO `street` VALUES (28826, '500101143', '500101', '李河镇', '李河镇', '108.270447', '30.810526', 19);
INSERT INTO `street` VALUES (28827, '500101144', '500101', '分水镇', '分水镇', '108.087791', '30.71735', 9);
INSERT INTO `street` VALUES (28828, '500101145', '500101', '余家镇', '余家镇', '107.968788', '30.798326', 45);
INSERT INTO `street` VALUES (28829, '500101146', '500101', '后山镇', '后山镇', '108.038292', '30.821404', 16);
INSERT INTO `street` VALUES (28830, '500101147', '500101', '弹子镇', '弹子镇', '108.015831', '30.852938', 6);
INSERT INTO `street` VALUES (28831, '500101148', '500101', '长岭镇', '长岭镇', '108.501732', '30.760777', 46);
INSERT INTO `street` VALUES (28832, '500101149', '500101', '新田镇', '新田镇', '108.408638', '30.684713', 41);
INSERT INTO `street` VALUES (28833, '500101150', '500101', '白羊镇', '白羊镇', '108.621544', '30.811668', 3);
INSERT INTO `street` VALUES (28834, '500101151', '500101', '龙驹镇', '龙驹镇', '108.644531', '30.605894', 22);
INSERT INTO `street` VALUES (28835, '500101152', '500101', '走马镇', '走马镇', '108.44648', '30.569057', 52);
INSERT INTO `street` VALUES (28836, '500101153', '500101', '罗田镇', '罗田镇', '108.574226', '30.509371', 24);
INSERT INTO `street` VALUES (28837, '500101154', '500101', '太龙镇', '太龙镇', '108.545868', '30.900826', 33);
INSERT INTO `street` VALUES (28838, '500101155', '500101', '长滩镇', '长滩镇', '108.60511', '30.735712', 48);
INSERT INTO `street` VALUES (28839, '500101156', '500101', '太安镇', '太安镇', '108.666153', '30.791836', 31);
INSERT INTO `street` VALUES (28840, '500101157', '500101', '白土镇', '白土镇', '108.819008', '30.591024', 2);
INSERT INTO `street` VALUES (28841, '500101158', '500101', '郭村镇', '郭村镇', '108.380249', '30.807808', 14);
INSERT INTO `street` VALUES (28842, '500101201', '500101', '柱山乡', '柱山乡', '108.282753', '30.727905', 51);
INSERT INTO `street` VALUES (28843, '500101212', '500101', '铁峰乡', '铁峰乡', '108.404488', '30.963776', 35);
INSERT INTO `street` VALUES (28844, '500101225', '500101', '溪口乡', '溪口乡', '108.337212', '30.600117', 40);
INSERT INTO `street` VALUES (28845, '500101226', '500101', '长坪乡', '长坪乡', '108.25853', '30.443211', 47);
INSERT INTO `street` VALUES (28846, '500101227', '500101', '燕山乡', '燕山乡', '108.30616', '30.556902', 44);
INSERT INTO `street` VALUES (28847, '500101234', '500101', '梨树乡', '梨树乡', '108.755646', '30.659405', 20);
INSERT INTO `street` VALUES (28848, '500101237', '500101', '普子乡', '普子乡', '108.821632', '30.567648', 26);
INSERT INTO `street` VALUES (28849, '500101238', '500101', '地宝土家族乡', '地宝土家族乡', '108.380249', '30.807808', 8);
INSERT INTO `street` VALUES (28850, '500101239', '500101', '恒合土家族乡', '恒合土家族乡', '108.759483', '30.529577', 15);
INSERT INTO `street` VALUES (28851, '500101244', '500101', '黄柏乡', '黄柏乡', '108.600967', '30.914276', 17);
INSERT INTO `street` VALUES (28852, '500101245', '500101', '九池乡', '九池乡', '108.345001', '30.769667', 18);
INSERT INTO `street` VALUES (28853, '500101247', '500101', '茨竹乡', '茨竹乡', '108.499626', '30.657448', 5);
INSERT INTO `street` VALUES (28854, '500102006', '500102', '敦仁街道', '敦仁街道', '107.404167', '29.70962', 6);
INSERT INTO `street` VALUES (28855, '500102007', '500102', '崇义街道', '崇义街道', '107.394867', '29.708834', 3);
INSERT INTO `street` VALUES (28856, '500102008', '500102', '荔枝街道', '荔枝街道', '107.387138', '29.710459', 12);
INSERT INTO `street` VALUES (28857, '500102009', '500102', '江北街道', '江北街道', '107.401199', '29.720968', 7);
INSERT INTO `street` VALUES (28858, '500102010', '500102', '江东街道', '江东街道', '107.418633', '29.698416', 8);
INSERT INTO `street` VALUES (28859, '500102011', '500102', '李渡街道', '李渡街道', '107.394905', '29.703651', 10);
INSERT INTO `street` VALUES (28860, '500102012', '500102', '龙桥街道', '龙桥街道', '107.394905', '29.703651', 13);
INSERT INTO `street` VALUES (28861, '500102013', '500102', '白涛街道', '白涛街道', '107.394905', '29.703651', 2);
INSERT INTO `street` VALUES (28862, '500102103', '500102', '南沱镇', '南沱镇', '107.530655', '29.850622', 17);
INSERT INTO `street` VALUES (28863, '500102107', '500102', '青羊镇', '青羊镇', '107.210075', '29.522041', 19);
INSERT INTO `street` VALUES (28864, '500102118', '500102', '百胜镇', '百胜镇', '107.38578', '29.810709', 1);
INSERT INTO `street` VALUES (28865, '500102119', '500102', '珍溪镇', '珍溪镇', '107.471031', '29.897129', 26);
INSERT INTO `street` VALUES (28866, '500102120', '500102', '清溪镇', '清溪镇', '107.46711', '29.799749', 18);
INSERT INTO `street` VALUES (28867, '500102121', '500102', '焦石镇', '焦石镇', '107.606102', '29.709215', 9);
INSERT INTO `street` VALUES (28868, '500102122', '500102', '马武镇', '马武镇', '107.322998', '29.586567', 16);
INSERT INTO `street` VALUES (28869, '500102123', '500102', '龙潭镇', '龙潭镇', '107.11396', '29.440367', 14);
INSERT INTO `street` VALUES (28870, '500102124', '500102', '蔺市镇', '蔺市镇', '107.199249', '29.661253', 11);
INSERT INTO `street` VALUES (28871, '500102125', '500102', '新妙镇', '新妙镇', '107.057068', '29.64937', 23);
INSERT INTO `street` VALUES (28872, '500102126', '500102', '石沱镇', '石沱镇', '107.143959', '29.711256', 20);
INSERT INTO `street` VALUES (28873, '500102127', '500102', '义和镇', '义和镇', '107.222893', '29.727404', 24);
INSERT INTO `street` VALUES (28874, '500102204', '500102', '罗云乡', '罗云乡', '107.609367', '29.778521', 15);
INSERT INTO `street` VALUES (28875, '500102206', '500102', '大木乡', '大木乡', '107.671577', '29.613533', 4);
INSERT INTO `street` VALUES (28876, '500102208', '500102', '武陵山乡', '武陵山乡', '107.550377', '29.512539', 22);
INSERT INTO `street` VALUES (28877, '500102216', '500102', '大顺乡', '大顺乡', '107.394905', '29.703651', 5);
INSERT INTO `street` VALUES (28878, '500102217', '500102', '增福乡', '增福乡', '106.991035', '29.506311', 25);
INSERT INTO `street` VALUES (28879, '500102222', '500102', '同乐乡', '同乐乡', '107.205093', '29.45521', 21);
INSERT INTO `street` VALUES (28880, '500103001', '500103', '七星岗街道', '七星岗街道', '106.562881', '29.556742', 9);
INSERT INTO `street` VALUES (28881, '500103003', '500103', '解放碑街道', '解放碑街道', '106.578674', '29.558037', 6);
INSERT INTO `street` VALUES (28882, '500103004', '500103', '两路口街道', '两路口街道', '106.562881', '29.556742', 7);
INSERT INTO `street` VALUES (28883, '500103005', '500103', '上清寺街道', '上清寺街道', '106.546684', '29.562553', 10);
INSERT INTO `street` VALUES (28884, '500103007', '500103', '菜园坝街道', '菜园坝街道', '106.545959', '29.547729', 1);
INSERT INTO `street` VALUES (28885, '500103008', '500103', '南纪门街道', '南纪门街道', '106.570015', '29.552114', 8);
INSERT INTO `street` VALUES (28886, '500103009', '500103', '望龙门街道', '望龙门街道', '106.58461', '29.557308', 12);
INSERT INTO `street` VALUES (28887, '500103010', '500103', '朝天门街道', '朝天门街道', '106.584999', '29.563562', 2);
INSERT INTO `street` VALUES (28888, '500103011', '500103', '大溪沟街道', '大溪沟街道', '106.555038', '29.560623', 4);
INSERT INTO `street` VALUES (28889, '500103012', '500103', '大坪街道', '大坪街道', '106.515892', '29.538324', 3);
INSERT INTO `street` VALUES (28890, '500103013', '500103', '化龙桥街道', '化龙桥街道', '106.511314', '29.552418', 5);
INSERT INTO `street` VALUES (28891, '500103014', '500103', '石油路街道', '石油路街道', '106.562881', '29.556742', 11);
INSERT INTO `street` VALUES (28892, '500104001', '500104', '新山村街道', '新山村街道', '106.486664', '29.482338', 7);
INSERT INTO `street` VALUES (28893, '500104002', '500104', '跃进村街道', '跃进村街道', '106.49437', '29.487091', 8);
INSERT INTO `street` VALUES (28894, '500104003', '500104', '九宫庙街道', '九宫庙街道', '106.485497', '29.474573', 4);
INSERT INTO `street` VALUES (28895, '500104004', '500104', '茄子溪街道', '茄子溪街道', '106.496216', '29.428833', 5);
INSERT INTO `street` VALUES (28896, '500104005', '500104', '春晖路街道', '春晖路街道', '106.48613', '29.481003', 2);
INSERT INTO `street` VALUES (28897, '500104101', '500104', '八桥镇', '八桥镇', '106.482742', '29.475655', 1);
INSERT INTO `street` VALUES (28898, '500104102', '500104', '建胜镇', '建胜镇', '106.496933', '29.428452', 3);
INSERT INTO `street` VALUES (28899, '500104103', '500104', '跳磴镇', '跳磴镇', '106.435623', '29.402033', 6);
INSERT INTO `street` VALUES (28900, '500105001', '500105', '华新街街道', '华新街街道', '106.532845', '29.575352', 6);
INSERT INTO `street` VALUES (28901, '500105002', '500105', '江北城街道', '江北城街道', '106.577827', '29.572512', 7);
INSERT INTO `street` VALUES (28902, '500105003', '500105', '石马河街道', '石马河街道', '106.478989', '29.582541', 8);
INSERT INTO `street` VALUES (28903, '500105004', '500105', '大石坝街道', '大石坝街道', '106.492821', '29.565594', 2);
INSERT INTO `street` VALUES (28904, '500105005', '500105', '寸滩街道', '寸滩街道', '106.570816', '29.594887', 1);
INSERT INTO `street` VALUES (28905, '500105006', '500105', '观音桥街道', '观音桥街道', '106.531387', '29.580219', 4);
INSERT INTO `street` VALUES (28906, '500105007', '500105', '五里店街道', '五里店街道', '106.55896', '29.582584', 11);
INSERT INTO `street` VALUES (28907, '500105008', '500105', '郭家沱街道', '郭家沱街道', '106.677505', '29.567482', 5);
INSERT INTO `street` VALUES (28908, '500105009', '500105', '铁山坪街道', '铁山坪街道', '106.532845', '29.575352', 9);
INSERT INTO `street` VALUES (28909, '500105100', '500105', '鱼嘴镇人民政府', '鱼嘴镇人民政府', '106.761086', '29.622879', 12);
INSERT INTO `street` VALUES (28910, '500105101', '500105', '复盛镇人民政府', '复盛镇人民政府', '106.792686', '29.644609', 3);
INSERT INTO `street` VALUES (28911, '500105102', '500105', '五宝镇人民政府', '五宝镇人民政府', '106.85611', '29.628412', 10);
INSERT INTO `street` VALUES (28912, '500106001', '500106', '小龙坎街道', '小龙坎街道', '106.467651', '29.554941', 21);
INSERT INTO `street` VALUES (28913, '500106002', '500106', '沙坪坝街道', '沙坪坝街道', '106.460739', '29.569702', 14);
INSERT INTO `street` VALUES (28914, '500106003', '500106', '渝碚路街道', '渝碚路街道', '106.454201', '29.541224', 24);
INSERT INTO `street` VALUES (28915, '500106004', '500106', '磁器口街道', '磁器口街道', '106.451675', '29.581535', 3);
INSERT INTO `street` VALUES (28916, '500106005', '500106', '童家桥街道', '童家桥街道', '106.443039', '29.569559', 18);
INSERT INTO `street` VALUES (28917, '500106006', '500106', '石井坡街道', '石井坡街道', '106.439079', '29.599342', 15);
INSERT INTO `street` VALUES (28918, '500106007', '500106', '詹家溪街道', '詹家溪街道', '106.448502', '29.603399', 25);
INSERT INTO `street` VALUES (28919, '500106008', '500106', '井口街道', '井口街道', '106.449532', '29.633104', 9);
INSERT INTO `street` VALUES (28920, '500106009', '500106', '歌乐山街道', '歌乐山街道', '106.419327', '29.564594', 5);
INSERT INTO `street` VALUES (28921, '500106010', '500106', '山洞街道', '山洞街道', '106.421402', '29.513258', 13);
INSERT INTO `street` VALUES (28922, '500106011', '500106', '新桥街道', '新桥街道', '106.43914', '29.524858', 22);
INSERT INTO `street` VALUES (28923, '500106012', '500106', '天星桥街道', '天星桥街道', '106.458298', '29.547422', 17);
INSERT INTO `street` VALUES (28924, '500106013', '500106', '土湾街道', '土湾街道', '106.473297', '29.554585', 19);
INSERT INTO `street` VALUES (28925, '500106014', '500106', '覃家岗街道', '覃家岗街道', '106.454201', '29.541224', 16);
INSERT INTO `street` VALUES (28926, '500106015', '500106', '陈家桥街道', '陈家桥街道', '106.454201', '29.541224', 2);
INSERT INTO `street` VALUES (28927, '500106016', '500106', '虎溪街道', '虎溪街道', '106.454201', '29.541224', 8);
INSERT INTO `street` VALUES (28928, '500106017', '500106', '西永街道', '西永街道', '106.454201', '29.541224', 23);
INSERT INTO `street` VALUES (28929, '500106018', '500106', '联芳街道', '联芳街道', '106.454201', '29.541224', 11);
INSERT INTO `street` VALUES (28930, '500106102', '500106', '井口镇', '井口镇', '106.454201', '29.541224', 10);
INSERT INTO `street` VALUES (28931, '500106103', '500106', '歌乐山镇', '歌乐山镇', '106.454201', '29.541224', 6);
INSERT INTO `street` VALUES (28932, '500106104', '500106', '青木关镇', '青木关镇', '106.302299', '29.671291', 12);
INSERT INTO `street` VALUES (28933, '500106105', '500106', '凤凰镇', '凤凰镇', '106.315666', '29.685404', 4);
INSERT INTO `street` VALUES (28934, '500106106', '500106', '回龙坝镇', '回龙坝镇', '106.383034', '29.704571', 7);
INSERT INTO `street` VALUES (28935, '500106108', '500106', '曾家镇', '曾家镇', '106.301453', '29.551912', 1);
INSERT INTO `street` VALUES (28936, '500106111', '500106', '土主镇', '土主镇', '106.372063', '29.631435', 20);
INSERT INTO `street` VALUES (28937, '500106112', '500106', '中梁镇', '中梁镇', '106.413116', '29.640408', 26);
INSERT INTO `street` VALUES (28938, '500107001', '500107', '杨家坪街道', '杨家坪街道', '106.511871', '29.507063', 15);
INSERT INTO `street` VALUES (28939, '500107002', '500107', '黄桷坪街道', '黄桷坪街道', '106.544151', '29.486889', 4);
INSERT INTO `street` VALUES (28940, '500107003', '500107', '谢家湾街道', '谢家湾街道', '106.518486', '29.522791', 13);
INSERT INTO `street` VALUES (28941, '500107004', '500107', '石坪桥街道', '石坪桥街道', '106.502266', '29.513498', 9);
INSERT INTO `street` VALUES (28942, '500107005', '500107', '石桥铺街道', '石桥铺街道', '106.480988', '29.523493', 10);
INSERT INTO `street` VALUES (28943, '500107006', '500107', '中梁山街道', '中梁山街道', '106.444809', '29.460732', 17);
INSERT INTO `street` VALUES (28944, '500107007', '500107', '渝州路街道', '渝州路街道', '106.480988', '29.523493', 16);
INSERT INTO `street` VALUES (28945, '500107100', '500107', '九龙镇', '九龙镇', '106.510071', '29.512291', 7);
INSERT INTO `street` VALUES (28946, '500107102', '500107', '华岩镇', '华岩镇', '106.444366', '29.459658', 5);
INSERT INTO `street` VALUES (28947, '500107103', '500107', '含谷镇', '含谷镇', '106.370819', '29.518295', 3);
INSERT INTO `street` VALUES (28948, '500107104', '500107', '金凤镇', '金凤镇', '106.313187', '29.517931', 6);
INSERT INTO `street` VALUES (28949, '500107105', '500107', '白市驿镇', '白市驿镇', '106.367531', '29.488058', 2);
INSERT INTO `street` VALUES (28950, '500107106', '500107', '走马镇', '走马镇', '106.298538', '29.46015', 18);
INSERT INTO `street` VALUES (28951, '500107107', '500107', '石板镇', '石板镇', '106.367851', '29.416616', 8);
INSERT INTO `street` VALUES (28952, '500107108', '500107', '巴福镇', '巴福镇', '106.331345', '29.41226', 1);
INSERT INTO `street` VALUES (28953, '500107109', '500107', '陶家镇', '陶家镇', '106.346725', '29.361006', 11);
INSERT INTO `street` VALUES (28954, '500107110', '500107', '西彭镇', '西彭镇', '106.333557', '29.298504', 14);
INSERT INTO `street` VALUES (28955, '500107111', '500107', '铜罐驿镇', '铜罐驿镇', '106.386101', '29.295605', 12);
INSERT INTO `street` VALUES (28956, '500108001', '500108', '铜元局街道', '铜元局街道', '106.545731', '29.537319', 11);
INSERT INTO `street` VALUES (28957, '500108002', '500108', '花园路街道', '花园路街道', '106.560814', '29.523993', 4);
INSERT INTO `street` VALUES (28958, '500108003', '500108', '南坪街道', '南坪街道', '106.568626', '29.53179', 7);
INSERT INTO `street` VALUES (28959, '500108004', '500108', '海棠溪街道', '海棠溪街道', '106.574249', '29.513531', 3);
INSERT INTO `street` VALUES (28960, '500108005', '500108', '龙门浩街道', '龙门浩街道', '106.560814', '29.523993', 6);
INSERT INTO `street` VALUES (28961, '500108006', '500108', '弹子石街道', '弹子石街道', '106.59034', '29.582348', 1);
INSERT INTO `street` VALUES (28962, '500108007', '500108', '南山街道', '南山街道', '106.628036', '29.556564', 9);
INSERT INTO `street` VALUES (28963, '500108008', '500108', '天文街道', '天文街道', '106.560814', '29.523993', 10);
INSERT INTO `street` VALUES (28964, '500108101', '500108', '南坪镇', '南坪镇', '106.57489', '29.522778', 8);
INSERT INTO `street` VALUES (28965, '500108102', '500108', '涂山镇', '涂山镇', '106.604538', '29.576004', 12);
INSERT INTO `street` VALUES (28966, '500108103', '500108', '鸡冠石镇', '鸡冠石镇', '106.613075', '29.594444', 5);
INSERT INTO `street` VALUES (28967, '500108105', '500108', '峡口镇', '峡口镇', '106.669037', '29.562241', 13);
INSERT INTO `street` VALUES (28968, '500108106', '500108', '长生桥镇', '长生桥镇', '106.668869', '29.50309', 15);
INSERT INTO `street` VALUES (28969, '500108107', '500108', '迎龙镇', '迎龙镇', '106.72126', '29.521755', 14);
INSERT INTO `street` VALUES (28970, '500108108', '500108', '广阳镇', '广阳镇', '106.775772', '29.594049', 2);
INSERT INTO `street` VALUES (28971, '500109001', '500109', '天生街道', '天生街道', '106.435371', '29.825607', 15);
INSERT INTO `street` VALUES (28972, '500109002', '500109', '朝阳街道', '朝阳街道', '106.439873', '29.828388', 3);
INSERT INTO `street` VALUES (28973, '500109003', '500109', '北温泉街道', '北温泉街道', '106.437866', '29.82543', 1);
INSERT INTO `street` VALUES (28974, '500109004', '500109', '东阳街道', '东阳街道', '106.442467', '29.838627', 5);
INSERT INTO `street` VALUES (28975, '500109005', '500109', '龙凤桥街道', '龙凤桥街道', '106.433884', '29.815872', 10);
INSERT INTO `street` VALUES (28976, '500109101', '500109', '歇马镇', '歇马镇', '106.374229', '29.762625', 17);
INSERT INTO `street` VALUES (28977, '500109102', '500109', '澄江镇', '澄江镇', '106.388245', '29.870728', 4);
INSERT INTO `street` VALUES (28978, '500109103', '500109', '蔡家岗镇', '蔡家岗镇', '106.471947', '29.731873', 2);
INSERT INTO `street` VALUES (28979, '500109104', '500109', '童家溪镇', '童家溪镇', '106.447914', '29.688135', 16);
INSERT INTO `street` VALUES (28980, '500109105', '500109', '天府镇', '天府镇', '106.498573', '29.863031', 14);
INSERT INTO `street` VALUES (28981, '500109108', '500109', '施家梁镇', '施家梁镇', '106.477333', '29.785076', 12);
INSERT INTO `street` VALUES (28982, '500109109', '500109', '水土镇', '水土镇', '106.501877', '29.783092', 13);
INSERT INTO `street` VALUES (28983, '500109110', '500109', '静观镇', '静观镇', '106.57019', '29.895388', 8);
INSERT INTO `street` VALUES (28984, '500109111', '500109', '柳荫镇', '柳荫镇', '106.610428', '29.952806', 9);
INSERT INTO `street` VALUES (28985, '500109112', '500109', '复兴镇', '复兴镇', '106.561592', '29.813299', 6);
INSERT INTO `street` VALUES (28986, '500109113', '500109', '三圣镇', '三圣镇', '106.627693', '29.891531', 11);
INSERT INTO `street` VALUES (28987, '500109116', '500109', '金刀峡镇', '金刀峡镇', '106.631683', '30.037048', 7);
INSERT INTO `street` VALUES (28988, '500112002', '500112', '双龙湖街道', '双龙湖街道', '106.630531', '29.708792', 19);
INSERT INTO `street` VALUES (28989, '500112004', '500112', '回兴街道', '回兴街道', '106.603653', '29.673201', 7);
INSERT INTO `street` VALUES (28990, '500112007', '500112', '鸳鸯街道', '鸳鸯街道', '106.56498', '29.661627', 24);
INSERT INTO `street` VALUES (28991, '500112008', '500112', '翠云街道', '翠云街道', '106.512848', '29.601452', 2);
INSERT INTO `street` VALUES (28992, '500112009', '500112', '人和街道', '人和街道', '106.529785', '29.623775', 16);
INSERT INTO `street` VALUES (28993, '500112010', '500112', '天宫殿街道', '天宫殿街道', '106.512848', '29.601452', 20);
INSERT INTO `street` VALUES (28994, '500112011', '500112', '龙溪街道', '龙溪街道', '106.514915', '29.584311', 12);
INSERT INTO `street` VALUES (28995, '500112012', '500112', '龙山街道', '龙山街道', '106.512848', '29.601452', 10);
INSERT INTO `street` VALUES (28996, '500112013', '500112', '龙塔街道', '龙塔街道', '106.548195', '29.597303', 11);
INSERT INTO `street` VALUES (28997, '500112014', '500112', '大竹林街道', '大竹林街道', '106.512848', '29.601452', 5);
INSERT INTO `street` VALUES (28998, '500112015', '500112', '悦来街道', '悦来街道', '106.512848', '29.601452', 25);
INSERT INTO `street` VALUES (28999, '500112016', '500112', '两路街道', '两路街道', '106.512848', '29.601452', 8);
INSERT INTO `street` VALUES (29000, '500112017', '500112', '双凤桥街道', '双凤桥街道', '106.631767', '29.716066', 18);
INSERT INTO `street` VALUES (29001, '500112018', '500112', '王家街道', '王家街道', '106.69841', '29.770918', 22);
INSERT INTO `street` VALUES (29002, '500112019', '500112', '礼嘉街道', '礼嘉街道', '106.512848', '29.601452', 9);
INSERT INTO `street` VALUES (29003, '500112129', '500112', '玉峰山镇', '玉峰山镇', '106.77549', '29.760544', 26);
INSERT INTO `street` VALUES (29004, '500112131', '500112', '龙兴镇', '龙兴镇', '106.795418', '29.696196', 13);
INSERT INTO `street` VALUES (29005, '500112133', '500112', '统景镇', '统景镇', '106.84449', '29.849535', 21);
INSERT INTO `street` VALUES (29006, '500112135', '500112', '大湾镇', '大湾镇', '106.824394', '30.016804', 4);
INSERT INTO `street` VALUES (29007, '500112138', '500112', '兴隆镇', '兴隆镇', '106.708168', '29.887329', 23);
INSERT INTO `street` VALUES (29008, '500112139', '500112', '木耳镇', '木耳镇', '106.645981', '29.801527', 15);
INSERT INTO `street` VALUES (29009, '500112140', '500112', '茨竹镇', '茨竹镇', '106.747269', '29.979002', 1);
INSERT INTO `street` VALUES (29010, '500112141', '500112', '古路镇', '古路镇', '106.766777', '29.850206', 6);
INSERT INTO `street` VALUES (29011, '500112142', '500112', '石船镇', '石船镇', '106.827553', '29.763828', 17);
INSERT INTO `street` VALUES (29012, '500112143', '500112', '大盛镇', '大盛镇', '106.902504', '29.889278', 3);
INSERT INTO `street` VALUES (29013, '500112144', '500112', '洛碛镇', '洛碛镇', '106.930687', '29.727762', 14);
INSERT INTO `street` VALUES (29014, '500113003', '500113', '龙洲湾街道', '龙洲湾街道', '106.519424', '29.38192', 11);
INSERT INTO `street` VALUES (29015, '500113004', '500113', '鱼洞街道', '鱼洞街道', '106.523651', '29.380032', 22);
INSERT INTO `street` VALUES (29016, '500113005', '500113', '花溪街道', '花溪街道', '106.519424', '29.38192', 5);
INSERT INTO `street` VALUES (29017, '500113006', '500113', '李家沱街道', '李家沱街道', '106.540932', '29.464689', 10);
INSERT INTO `street` VALUES (29018, '500113007', '500113', '南泉街道', '南泉街道', '106.663986', '29.440792', 15);
INSERT INTO `street` VALUES (29019, '500113008', '500113', '一品街道', '一品街道', '106.519424', '29.38192', 21);
INSERT INTO `street` VALUES (29020, '500113009', '500113', '南彭街道', '南彭街道', '106.519424', '29.38192', 14);
INSERT INTO `street` VALUES (29021, '500113010', '500113', '惠民街道', '惠民街道', '106.708839', '29.459007', 6);
INSERT INTO `street` VALUES (29022, '500113103', '500113', '界石镇', '界石镇', '106.609032', '29.383398', 9);
INSERT INTO `street` VALUES (29023, '500113107', '500113', '安澜镇', '安澜镇', '106.582932', '29.251051', 1);
INSERT INTO `street` VALUES (29024, '500113108', '500113', '跳石镇', '跳石镇', '106.650391', '29.272682', 20);
INSERT INTO `street` VALUES (29025, '500113109', '500113', '木洞镇', '木洞镇', '106.843323', '29.570223', 13);
INSERT INTO `street` VALUES (29026, '500113110', '500113', '双河口镇', '双河口镇', '106.919037', '29.615505', 18);
INSERT INTO `street` VALUES (29027, '500113111', '500113', '麻柳嘴镇', '麻柳嘴镇', '106.944885', '29.692181', 12);
INSERT INTO `street` VALUES (29028, '500113112', '500113', '丰盛镇', '丰盛镇', '106.93309', '29.530216', 4);
INSERT INTO `street` VALUES (29029, '500113113', '500113', '二圣镇', '二圣镇', '106.778305', '29.461832', 3);
INSERT INTO `street` VALUES (29030, '500113114', '500113', '东泉镇', '东泉镇', '106.861862', '29.453314', 2);
INSERT INTO `street` VALUES (29031, '500113115', '500113', '姜家镇', '姜家镇', '106.825714', '29.386744', 7);
INSERT INTO `street` VALUES (29032, '500113116', '500113', '天星寺镇', '天星寺镇', '106.771172', '29.344883', 19);
INSERT INTO `street` VALUES (29033, '500113117', '500113', '接龙镇', '接龙镇', '106.791321', '29.243797', 8);
INSERT INTO `street` VALUES (29034, '500113118', '500113', '石滩镇', '石滩镇', '106.88446', '29.180695', 17);
INSERT INTO `street` VALUES (29035, '500113119', '500113', '石龙镇', '石龙镇', '106.895027', '29.278952', 16);
INSERT INTO `street` VALUES (29036, '500114001', '500114', '城东街道', '城东街道', '108.790947', '29.523026', 4);
INSERT INTO `street` VALUES (29037, '500114002', '500114', '城南街道', '城南街道', '108.782631', '29.516851', 5);
INSERT INTO `street` VALUES (29038, '500114003', '500114', '城西街道', '城西街道', '108.774727', '29.531084', 6);
INSERT INTO `street` VALUES (29039, '500114004', '500114', '正阳街道', '正阳街道', '108.782578', '29.527548', 27);
INSERT INTO `street` VALUES (29040, '500114005', '500114', '舟白街道', '舟白街道', '108.782578', '29.527548', 29);
INSERT INTO `street` VALUES (29041, '500114006', '500114', '冯家街道', '冯家街道', '108.782578', '29.527548', 8);
INSERT INTO `street` VALUES (29042, '500114105', '500114', '阿蓬江镇', '阿蓬江镇', '108.782578', '29.527548', 1);
INSERT INTO `street` VALUES (29043, '500114106', '500114', '石会镇', '石会镇', '108.644188', '29.559845', 19);
INSERT INTO `street` VALUES (29044, '500114107', '500114', '黑溪镇', '黑溪镇', '108.548248', '29.614723', 9);
INSERT INTO `street` VALUES (29045, '500114108', '500114', '黄溪镇', '黄溪镇', '108.608009', '29.758436', 10);
INSERT INTO `street` VALUES (29046, '500114109', '500114', '黎水镇', '黎水镇', '108.651802', '29.82283', 14);
INSERT INTO `street` VALUES (29047, '500114110', '500114', '金溪镇', '金溪镇', '108.702087', '29.391632', 12);
INSERT INTO `street` VALUES (29048, '500114111', '500114', '马喇镇', '马喇镇', '108.860298', '29.275208', 15);
INSERT INTO `street` VALUES (29049, '500114112', '500114', '濯水镇', '濯水镇', '108.77774', '29.299852', 30);
INSERT INTO `street` VALUES (29050, '500114113', '500114', '石家镇', '石家镇', '108.63504', '29.253994', 20);
INSERT INTO `street` VALUES (29051, '500114114', '500114', '鹅池镇', '鹅池镇', '108.598396', '29.134169', 7);
INSERT INTO `street` VALUES (29052, '500114117', '500114', '小南海镇', '小南海镇', '108.765068', '29.649343', 25);
INSERT INTO `street` VALUES (29053, '500114119', '500114', '邻鄂镇', '邻鄂镇', '108.856461', '29.420069', 13);
INSERT INTO `street` VALUES (29054, '500114245', '500114', '中塘乡', '中塘乡', '108.833839', '29.605446', 28);
INSERT INTO `street` VALUES (29055, '500114246', '500114', '蓬东乡', '蓬东乡', '108.833214', '29.383282', 16);
INSERT INTO `street` VALUES (29056, '500114247', '500114', '沙坝乡', '沙坝乡', '108.63887', '29.481821', 17);
INSERT INTO `street` VALUES (29057, '500114248', '500114', '白石乡', '白石乡', '108.574837', '29.678446', 2);
INSERT INTO `street` VALUES (29058, '500114249', '500114', '杉岭乡', '杉岭乡', '108.627556', '29.732225', 18);
INSERT INTO `street` VALUES (29059, '500114250', '500114', '太极乡', '太极乡', '108.671112', '29.32431', 23);
INSERT INTO `street` VALUES (29060, '500114251', '500114', '水田乡', '水田乡', '108.746071', '29.394878', 22);
INSERT INTO `street` VALUES (29061, '500114252', '500114', '白土乡', '白土乡', '108.654236', '29.380329', 3);
INSERT INTO `street` VALUES (29062, '500114253', '500114', '金洞乡', '金洞乡', '108.855469', '29.19742', 11);
INSERT INTO `street` VALUES (29063, '500114254', '500114', '五里乡', '五里乡', '108.844978', '29.371588', 24);
INSERT INTO `street` VALUES (29064, '500114255', '500114', '水市乡', '水市乡', '108.705177', '29.23815', 21);
INSERT INTO `street` VALUES (29065, '500114256', '500114', '新华乡', '新华乡', '108.636017', '29.32185', 26);
INSERT INTO `street` VALUES (29066, '500115001', '500115', '凤城街道', '凤城街道', '107.073555', '29.823944', 4);
INSERT INTO `street` VALUES (29067, '500115002', '500115', '晏家街道', '晏家街道', '107.074852', '29.833672', 15);
INSERT INTO `street` VALUES (29068, '500115003', '500115', '江南街道', '江南街道', '107.074852', '29.833672', 8);
INSERT INTO `street` VALUES (29069, '500115004', '500115', '渡舟街道', '渡舟街道', '107.074852', '29.833672', 3);
INSERT INTO `street` VALUES (29070, '500115123', '500115', '邻封镇', '邻封镇', '107.22226', '29.886339', 9);
INSERT INTO `street` VALUES (29071, '500115124', '500115', '但渡镇', '但渡镇', '107.140091', '29.828119', 2);
INSERT INTO `street` VALUES (29072, '500115125', '500115', '云集镇', '云集镇', '107.294922', '29.894318', 16);
INSERT INTO `street` VALUES (29073, '500115126', '500115', '长寿湖镇', '长寿湖镇', '107.245613', '29.901613', 18);
INSERT INTO `street` VALUES (29074, '500115127', '500115', '双龙镇', '双龙镇', '107.212547', '29.955357', 12);
INSERT INTO `street` VALUES (29075, '500115128', '500115', '龙河镇', '龙河镇', '107.225853', '30.003689', 10);
INSERT INTO `street` VALUES (29076, '500115129', '500115', '石堰镇', '石堰镇', '107.181778', '30.079676', 11);
INSERT INTO `street` VALUES (29077, '500115130', '500115', '云台镇', '云台镇', '107.210968', '30.132832', 17);
INSERT INTO `street` VALUES (29078, '500115131', '500115', '海棠镇', '海棠镇', '107.240082', '30.166416', 6);
INSERT INTO `street` VALUES (29079, '500115132', '500115', '葛兰镇', '葛兰镇', '107.124413', '30.028896', 5);
INSERT INTO `street` VALUES (29080, '500115133', '500115', '新市镇', '新市镇', '107.122673', '29.951477', 14);
INSERT INTO `street` VALUES (29081, '500115135', '500115', '八颗镇', '八颗镇', '107.02816', '29.898363', 1);
INSERT INTO `street` VALUES (29082, '500115136', '500115', '洪湖镇', '洪湖镇', '106.960861', '29.996099', 7);
INSERT INTO `street` VALUES (29083, '500115137', '500115', '万顺镇', '万顺镇', '106.975624', '30.037283', 13);
INSERT INTO `street` VALUES (29084, '500223001', '500223', '桂林街道', '桂林街道', '105.812668', '30.239874', 5);
INSERT INTO `street` VALUES (29085, '500223002', '500223', '梓潼街道', '梓潼街道', '105.822571', '30.174704', 22);
INSERT INTO `street` VALUES (29086, '500223101', '500223', '上和镇', '上和镇', '105.93425', '30.161856', 11);
INSERT INTO `street` VALUES (29087, '500223102', '500223', '龙形镇', '龙形镇', '105.914825', '30.245571', 8);
INSERT INTO `street` VALUES (29088, '500223103', '500223', '古溪镇', '古溪镇', '105.879265', '30.326162', 6);
INSERT INTO `street` VALUES (29089, '500223104', '500223', '宝龙镇', '宝龙镇', '105.926979', '30.349379', 1);
INSERT INTO `street` VALUES (29090, '500223107', '500223', '玉溪镇', '玉溪镇', '105.783569', '30.318333', 21);
INSERT INTO `street` VALUES (29091, '500223108', '500223', '米心镇', '米心镇', '105.775932', '30.373791', 9);
INSERT INTO `street` VALUES (29092, '500223109', '500223', '群力镇', '群力镇', '105.843048', '30.298273', 10);
INSERT INTO `street` VALUES (29093, '500223110', '500223', '双江镇', '双江镇', '105.752892', '30.211924', 13);
INSERT INTO `street` VALUES (29094, '500223112', '500223', '花岩镇', '花岩镇', '105.644943', '30.254957', 7);
INSERT INTO `street` VALUES (29095, '500223113', '500223', '柏梓镇', '柏梓镇', '105.719398', '30.088713', 3);
INSERT INTO `street` VALUES (29096, '500223114', '500223', '崇龛镇', '崇龛镇', '105.619766', '30.150539', 4);
INSERT INTO `street` VALUES (29097, '500223115', '500223', '塘坝镇', '塘坝镇', '105.803375', '30.013016', 15);
INSERT INTO `street` VALUES (29098, '500223116', '500223', '新胜镇', '新胜镇', '105.759071', '29.951107', 20);
INSERT INTO `street` VALUES (29099, '500223117', '500223', '太安镇', '太安镇', '105.819122', '30.065632', 14);
INSERT INTO `street` VALUES (29100, '500223119', '500223', '小渡镇', '小渡镇', '105.892891', '29.957407', 19);
INSERT INTO `street` VALUES (29101, '500223120', '500223', '卧佛镇', '卧佛镇', '105.794563', '29.902983', 17);
INSERT INTO `street` VALUES (29102, '500223121', '500223', '五桂镇', '五桂镇', '105.76284', '29.814236', 18);
INSERT INTO `street` VALUES (29103, '500223122', '500223', '田家镇', '田家镇', '105.84182', '30.189554', 16);
INSERT INTO `street` VALUES (29104, '500223123', '500223', '别口镇', '别口镇', '105.84182', '30.189554', 2);
INSERT INTO `street` VALUES (29105, '500223124', '500223', '寿桥镇', '寿桥镇', '105.84182', '30.189554', 12);
INSERT INTO `street` VALUES (29106, '500224001', '500224', '巴川街道', '巴川街道', '106.054947', '29.839945', 3);
INSERT INTO `street` VALUES (29107, '500224002', '500224', '东城街道', '东城街道', '106.136765', '29.845972', 6);
INSERT INTO `street` VALUES (29108, '500224003', '500224', '南城街道', '南城街道', '106.054947', '29.839945', 14);
INSERT INTO `street` VALUES (29109, '500224101', '500224', '土桥镇', '土桥镇', '106.012985', '29.769053', 23);
INSERT INTO `street` VALUES (29110, '500224103', '500224', '二坪镇', '二坪镇', '106.161156', '29.893269', 7);
INSERT INTO `street` VALUES (29111, '500224104', '500224', '水口镇', '水口镇', '106.119972', '29.92454', 21);
INSERT INTO `street` VALUES (29112, '500224105', '500224', '安居镇', '安居镇', '106.033859', '29.986338', 1);
INSERT INTO `street` VALUES (29113, '500224106', '500224', '白羊镇', '白羊镇', '106.090126', '29.956835', 4);
INSERT INTO `street` VALUES (29114, '500224107', '500224', '平滩镇', '平滩镇', '105.885162', '29.839088', 15);
INSERT INTO `street` VALUES (29115, '500224110', '500224', '石鱼镇', '石鱼镇', '106.101494', '29.766674', 19);
INSERT INTO `street` VALUES (29116, '500224111', '500224', '福果镇', '福果镇', '106.054741', '29.693317', 8);
INSERT INTO `street` VALUES (29117, '500224113', '500224', '维新镇', '维新镇', '105.897827', '30.041746', 25);
INSERT INTO `street` VALUES (29118, '500224114', '500224', '高楼镇', '高楼镇', '105.981651', '30.047373', 9);
INSERT INTO `street` VALUES (29119, '500224115', '500224', '大庙镇', '大庙镇', '106.077118', '29.639448', 5);
INSERT INTO `street` VALUES (29120, '500224116', '500224', '围龙镇', '围龙镇', '106.014877', '29.617842', 24);
INSERT INTO `street` VALUES (29121, '500224117', '500224', '华兴镇', '华兴镇', '106.077347', '29.594891', 10);
INSERT INTO `street` VALUES (29122, '500224120', '500224', '永嘉镇', '永嘉镇', '105.99868', '29.57082', 28);
INSERT INTO `street` VALUES (29123, '500224121', '500224', '安溪镇', '安溪镇', '106.045914', '29.561399', 2);
INSERT INTO `street` VALUES (29124, '500224122', '500224', '西河镇', '西河镇', '105.929329', '29.56814', 27);
INSERT INTO `street` VALUES (29125, '500224124', '500224', '太平镇', '太平镇', '106.040749', '29.900898', 22);
INSERT INTO `street` VALUES (29126, '500224125', '500224', '旧县镇', '旧县镇', '106.211967', '29.859379', 12);
INSERT INTO `street` VALUES (29127, '500224126', '500224', '虎峰镇', '虎峰镇', '106.118866', '29.710995', 11);
INSERT INTO `street` VALUES (29128, '500224127', '500224', '少云镇', '少云镇', '105.987701', '29.983454', 18);
INSERT INTO `street` VALUES (29129, '500224128', '500224', '蒲吕镇', '蒲吕镇', '106.166603', '29.811853', 16);
INSERT INTO `street` VALUES (29130, '500224129', '500224', '侣俸镇', '侣俸镇', '105.980301', '29.85364', 13);
INSERT INTO `street` VALUES (29131, '500224130', '500224', '小林镇', '小林镇', '106.054947', '29.839945', 26);
INSERT INTO `street` VALUES (29132, '500224131', '500224', '双山镇', '双山镇', '106.054947', '29.839945', 20);
INSERT INTO `street` VALUES (29133, '500224132', '500224', '庆隆镇', '庆隆镇', '106.054947', '29.839945', 17);
INSERT INTO `street` VALUES (29134, '500226001', '500226', '昌元街道', '昌元街道', '105.594063', '29.403627', 2);
INSERT INTO `street` VALUES (29135, '500226002', '500226', '昌洲街道', '昌洲街道', '105.594063', '29.403627', 3);
INSERT INTO `street` VALUES (29136, '500226003', '500226', '广顺街道', '广顺街道', '105.594063', '29.403627', 5);
INSERT INTO `street` VALUES (29137, '500226004', '500226', '双河街道', '双河街道', '105.574287', '29.317087', 17);
INSERT INTO `street` VALUES (29138, '500226005', '500226', '安富街道', '安富街道', '105.594063', '29.403627', 1);
INSERT INTO `street` VALUES (29139, '500226006', '500226', '峰高街道', '峰高街道', '105.594063', '29.403627', 4);
INSERT INTO `street` VALUES (29140, '500226103', '500226', '直升镇', '直升镇', '105.659889', '29.368063', 21);
INSERT INTO `street` VALUES (29141, '500226104', '500226', '路孔镇', '路孔镇', '105.651512', '29.48588', 10);
INSERT INTO `street` VALUES (29142, '500226106', '500226', '清江镇', '清江镇', '105.478142', '29.28474', 12);
INSERT INTO `street` VALUES (29143, '500226107', '500226', '仁义镇', '仁义镇', '105.486237', '29.502171', 15);
INSERT INTO `street` VALUES (29144, '500226108', '500226', '河包镇', '河包镇', '105.550644', '29.559443', 8);
INSERT INTO `street` VALUES (29145, '500226109', '500226', '古昌镇', '古昌镇', '105.595825', '29.481693', 7);
INSERT INTO `street` VALUES (29146, '500226110', '500226', '吴家镇', '吴家镇', '105.399147', '29.630026', 19);
INSERT INTO `street` VALUES (29147, '500226111', '500226', '观胜镇', '观胜镇', '105.443634', '29.573528', 6);
INSERT INTO `street` VALUES (29148, '500226112', '500226', '铜鼓镇', '铜鼓镇', '105.472633', '29.600706', 18);
INSERT INTO `street` VALUES (29149, '500226113', '500226', '清流镇', '清流镇', '105.342873', '29.587978', 13);
INSERT INTO `street` VALUES (29150, '500226114', '500226', '盘龙镇', '盘龙镇', '105.372856', '29.497297', 11);
INSERT INTO `street` VALUES (29151, '500226115', '500226', '远觉镇', '远觉镇', '105.324982', '29.55451', 20);
INSERT INTO `street` VALUES (29152, '500226117', '500226', '清升镇', '清升镇', '105.518288', '29.312735', 14);
INSERT INTO `street` VALUES (29153, '500226118', '500226', '荣隆镇', '荣隆镇', '105.455879', '29.429756', 16);
INSERT INTO `street` VALUES (29154, '500226119', '500226', '龙集镇', '龙集镇', '105.405235', '29.44524', 9);
INSERT INTO `street` VALUES (29155, '500227001', '500227', '璧城街道', '璧城街道', '106.231491', '29.585413', 2);
INSERT INTO `street` VALUES (29156, '500227003', '500227', '璧泉街道', '璧泉街道', '106.231125', '29.59358', 3);
INSERT INTO `street` VALUES (29157, '500227004', '500227', '青杠街道', '青杠街道', '106.235619', '29.465986', 12);
INSERT INTO `street` VALUES (29158, '500227005', '500227', '来凤街道', '来凤街道', '106.231125', '29.59358', 11);
INSERT INTO `street` VALUES (29159, '500227006', '500227', '丁家街道', '丁家街道', '106.231125', '29.59358', 6);
INSERT INTO `street` VALUES (29160, '500227007', '500227', '大路街道', '大路街道', '106.231125', '29.59358', 4);
INSERT INTO `street` VALUES (29161, '500227100', '500227', '八塘镇', '八塘镇', '106.299515', '29.831923', 1);
INSERT INTO `street` VALUES (29162, '500227101', '500227', '七塘镇', '七塘镇', '106.287773', '29.775288', 13);
INSERT INTO `street` VALUES (29163, '500227103', '500227', '河边镇', '河边镇', '106.205307', '29.650824', 9);
INSERT INTO `street` VALUES (29164, '500227104', '500227', '福禄镇', '福禄镇', '106.143082', '29.602575', 7);
INSERT INTO `street` VALUES (29165, '500227105', '500227', '大兴镇', '大兴镇', '106.166687', '29.54998', 5);
INSERT INTO `street` VALUES (29166, '500227106', '500227', '正兴镇', '正兴镇', '106.138191', '29.452288', 15);
INSERT INTO `street` VALUES (29167, '500227108', '500227', '广普镇', '广普镇', '106.153267', '29.328665', 8);
INSERT INTO `street` VALUES (29168, '500227109', '500227', '三合镇', '三合镇', '106.107841', '29.342518', 14);
INSERT INTO `street` VALUES (29169, '500227110', '500227', '健龙镇', '健龙镇', '106.231125', '29.59358', 10);
INSERT INTO `street` VALUES (29170, '500228001', '500228', '梁平县梁山街道', '梁平县梁山街道', '107.800034', '30.672169', 14);
INSERT INTO `street` VALUES (29171, '500228002', '500228', '梁平县双桂街道', '梁平县双桂街道', '107.800034', '30.672169', 17);
INSERT INTO `street` VALUES (29172, '500228101', '500228', '仁贤镇', '仁贤镇', '107.682755', '30.657135', 26);
INSERT INTO `street` VALUES (29173, '500228102', '500228', '礼让镇', '礼让镇', '107.641121', '30.679266', 18);
INSERT INTO `street` VALUES (29174, '500228103', '500228', '云龙镇', '云龙镇', '107.650383', '30.516945', 33);
INSERT INTO `street` VALUES (29175, '500228104', '500228', '屏锦镇', '屏锦镇', '107.551743', '30.609638', 23);
INSERT INTO `street` VALUES (29176, '500228106', '500228', '袁驿镇', '袁驿镇', '107.523102', '30.737843', 32);
INSERT INTO `street` VALUES (29177, '500228107', '500228', '新盛镇', '新盛镇', '107.734474', '30.840277', 30);
INSERT INTO `street` VALUES (29178, '500228108', '500228', '福禄镇', '福禄镇', '107.975113', '30.649956', 6);
INSERT INTO `street` VALUES (29179, '500228109', '500228', '金带镇', '金带镇', '107.706032', '30.596378', 12);
INSERT INTO `street` VALUES (29180, '500228110', '500228', '聚奎镇', '聚奎镇', '107.599174', '30.635284', 13);
INSERT INTO `street` VALUES (29181, '500228111', '500228', '明达镇', '明达镇', '107.666443', '30.721081', 21);
INSERT INTO `street` VALUES (29182, '500228112', '500228', '荫平镇', '荫平镇', '107.583305', '30.536053', 31);
INSERT INTO `street` VALUES (29183, '500228113', '500228', '和林镇', '和林镇', '107.68821', '30.574396', 8);
INSERT INTO `street` VALUES (29184, '500228114', '500228', '回龙镇', '回龙镇', '107.488762', '30.523132', 11);
INSERT INTO `street` VALUES (29185, '500228115', '500228', '碧山镇', '碧山镇', '107.463013', '30.766905', 2);
INSERT INTO `street` VALUES (29186, '500228116', '500228', '虎城镇', '虎城镇', '107.549835', '30.808712', 10);
INSERT INTO `street` VALUES (29187, '500228117', '500228', '七星镇', '七星镇', '107.480446', '30.678329', 24);
INSERT INTO `street` VALUES (29188, '500228118', '500228', '龙门镇', '龙门镇', '107.696053', '30.792887', 19);
INSERT INTO `street` VALUES (29189, '500228119', '500228', '文化镇', '文化镇', '107.783669', '30.809019', 29);
INSERT INTO `street` VALUES (29190, '500228120', '500228', '合兴镇', '合兴镇', '107.829475', '30.741238', 9);
INSERT INTO `street` VALUES (29191, '500228121', '500228', '石安镇', '石安镇', '107.985367', '30.585678', 27);
INSERT INTO `street` VALUES (29192, '500228122', '500228', '柏家镇', '柏家镇', '107.913338', '30.587053', 3);
INSERT INTO `street` VALUES (29193, '500228123', '500228', '大观镇', '大观镇', '107.81514', '30.549229', 5);
INSERT INTO `street` VALUES (29194, '500228124', '500228', '竹山镇', '竹山镇', '107.584457', '30.712555', 34);
INSERT INTO `street` VALUES (29195, '500228125', '500228', '蟠龙镇', '蟠龙镇', '107.853394', '30.632578', 22);
INSERT INTO `street` VALUES (29196, '500228200', '500228', '安胜乡', '安胜乡', '107.729752', '30.685123', 1);
INSERT INTO `street` VALUES (29197, '500228201', '500228', '铁门乡', '铁门乡', '107.722977', '30.498932', 28);
INSERT INTO `street` VALUES (29198, '500228202', '500228', '龙胜乡', '龙胜乡', '107.560287', '30.78702', 20);
INSERT INTO `street` VALUES (29199, '500228203', '500228', '复平乡', '复平乡', '107.887978', '30.766705', 7);
INSERT INTO `street` VALUES (29200, '500228205', '500228', '紫照乡', '紫照乡', '107.946518', '30.527033', 35);
INSERT INTO `street` VALUES (29201, '500228206', '500228', '城北乡', '城北乡', '107.793976', '30.715612', 4);
INSERT INTO `street` VALUES (29202, '500228207', '500228', '曲水乡', '曲水乡', '108.053078', '30.695436', 25);
INSERT INTO `street` VALUES (29203, '500228400', '500228', '梁平县农场', '梁平县农场', '107.800034', '30.672169', 15);
INSERT INTO `street` VALUES (29204, '500228401', '500228', '梁平县双桂工业园区', '梁平县双桂工业园区', '107.709045', '30.607754', 16);
INSERT INTO `street` VALUES (29205, '500229001', '500229', '葛城街道', '葛城街道', '108.661606', '31.944481', 8);
INSERT INTO `street` VALUES (29206, '500229002', '500229', '复兴街道', '复兴街道', '108.661087', '31.941029', 4);
INSERT INTO `street` VALUES (29207, '500229102', '500229', '巴山镇', '巴山镇', '108.477676', '32.108795', 1);
INSERT INTO `street` VALUES (29208, '500229103', '500229', '坪坝镇', '坪坝镇', '108.527878', '31.993908', 18);
INSERT INTO `street` VALUES (29209, '500229104', '500229', '庙坝镇', '庙坝镇', '108.526299', '31.931431', 15);
INSERT INTO `street` VALUES (29210, '500229105', '500229', '明通镇', '明通镇', '108.544914', '31.770424', 16);
INSERT INTO `street` VALUES (29211, '500229106', '500229', '修齐镇', '修齐镇', '108.790436', '31.874376', 21);
INSERT INTO `street` VALUES (29212, '500229107', '500229', '高观镇', '高观镇', '108.896111', '31.848982', 5);
INSERT INTO `street` VALUES (29213, '500229108', '500229', '高燕镇', '高燕镇', '108.664902', '31.946293', 7);
INSERT INTO `street` VALUES (29214, '500229201', '500229', '龙田乡', '龙田乡', '108.639481', '31.971676', 14);
INSERT INTO `street` VALUES (29215, '500229202', '500229', '北屏乡', '北屏乡', '108.787369', '31.969685', 2);
INSERT INTO `street` VALUES (29216, '500229204', '500229', '高楠乡', '高楠乡', '108.525795', '32.127731', 6);
INSERT INTO `street` VALUES (29217, '500229205', '500229', '左岚乡', '左岚乡', '108.460747', '32.142921', 25);
INSERT INTO `street` VALUES (29218, '500229208', '500229', '沿河乡', '沿河乡', '108.40097', '32.055794', 22);
INSERT INTO `street` VALUES (29219, '500229210', '500229', '双河乡', '双河乡', '108.357224', '31.93828', 19);
INSERT INTO `street` VALUES (29220, '500229211', '500229', '蓼子乡', '蓼子乡', '108.651253', '31.808939', 13);
INSERT INTO `street` VALUES (29221, '500229212', '500229', '鸡鸣乡', '鸡鸣乡', '108.606621', '31.710241', 11);
INSERT INTO `street` VALUES (29222, '500229213', '500229', '咸宜乡', '咸宜乡', '108.664658', '31.684097', 20);
INSERT INTO `street` VALUES (29223, '500229214', '500229', '周溪乡', '周溪乡', '108.482445', '31.816547', 24);
INSERT INTO `street` VALUES (29224, '500229216', '500229', '明中乡', '明中乡', '108.819313', '31.729862', 17);
INSERT INTO `street` VALUES (29225, '500229217', '500229', '治平乡', '治平乡', '108.812401', '31.799725', 23);
INSERT INTO `street` VALUES (29226, '500229219', '500229', '岚天乡', '岚天乡', '108.896599', '31.918253', 12);
INSERT INTO `street` VALUES (29227, '500229220', '500229', '厚坪乡', '厚坪乡', '108.944916', '31.736015', 10);
INSERT INTO `street` VALUES (29228, '500229221', '500229', '河鱼乡', '河鱼乡', '108.958755', '31.866274', 9);
INSERT INTO `street` VALUES (29229, '500229223', '500229', '东安乡', '东安乡', '109.099724', '31.77405', 3);
INSERT INTO `street` VALUES (29230, '500230001', '500230', '三合街道', '三合街道', '107.732483', '29.866425', 16);
INSERT INTO `street` VALUES (29231, '500230002', '500230', '名山街道', '名山街道', '107.732483', '29.866425', 12);
INSERT INTO `street` VALUES (29232, '500230101', '500230', '虎威镇', '虎威镇', '107.645546', '29.901056', 6);
INSERT INTO `street` VALUES (29233, '500230102', '500230', '社坛镇', '社坛镇', '107.62114', '29.987841', 19);
INSERT INTO `street` VALUES (29234, '500230103', '500230', '三元镇', '三元镇', '107.660767', '30.099333', 18);
INSERT INTO `street` VALUES (29235, '500230104', '500230', '许明寺镇', '许明寺镇', '107.732483', '29.866425', 29);
INSERT INTO `street` VALUES (29236, '500230105', '500230', '董家镇', '董家镇', '107.712761', '30.219362', 3);
INSERT INTO `street` VALUES (29237, '500230106', '500230', '树人镇', '树人镇', '107.751015', '29.977882', 23);
INSERT INTO `street` VALUES (29238, '500230107', '500230', '十直镇', '十直镇', '107.80275', '30.047842', 20);
INSERT INTO `street` VALUES (29239, '500230109', '500230', '高家镇', '高家镇', '107.858337', '30.00563', 5);
INSERT INTO `street` VALUES (29240, '500230110', '500230', '兴义镇', '兴义镇', '107.824905', '29.949305', 28);
INSERT INTO `street` VALUES (29241, '500230111', '500230', '双路镇', '双路镇', '107.783089', '29.858292', 22);
INSERT INTO `street` VALUES (29242, '500230112', '500230', '江池镇', '江池镇', '108.03611', '29.907892', 7);
INSERT INTO `street` VALUES (29243, '500230113', '500230', '龙河镇', '龙河镇', '107.989899', '29.831623', 10);
INSERT INTO `street` VALUES (29244, '500230114', '500230', '武平镇', '武平镇', '108.096703', '29.790222', 25);
INSERT INTO `street` VALUES (29245, '500230115', '500230', '包鸾镇', '包鸾镇', '107.687866', '29.758226', 2);
INSERT INTO `street` VALUES (29246, '500230116', '500230', '湛普镇', '湛普镇', '107.645241', '29.839729', 30);
INSERT INTO `street` VALUES (29247, '500230118', '500230', '南天湖镇', '南天湖镇', '107.924126', '29.697842', 13);
INSERT INTO `street` VALUES (29248, '500230119', '500230', '保合镇', '保合镇', '107.732483', '29.866425', 1);
INSERT INTO `street` VALUES (29249, '500230120', '500230', '兴龙镇', '兴龙镇', '107.732483', '29.866425', 27);
INSERT INTO `street` VALUES (29250, '500230121', '500230', '仁沙镇', '仁沙镇', '107.732483', '29.866425', 15);
INSERT INTO `street` VALUES (29251, '500230122', '500230', '龙孔镇', '龙孔镇', '107.732483', '29.866425', 11);
INSERT INTO `street` VALUES (29252, '500230123', '500230', '暨龙镇', '暨龙镇', '107.732483', '29.866425', 8);
INSERT INTO `street` VALUES (29253, '500230124', '500230', '双龙镇', '双龙镇', '107.732483', '29.866425', 21);
INSERT INTO `street` VALUES (29254, '500230125', '500230', '仙女湖镇', '仙女湖镇', '107.732483', '29.866425', 26);
INSERT INTO `street` VALUES (29255, '500230202', '500230', '青龙乡', '青龙乡', '107.797234', '30.164148', 14);
INSERT INTO `street` VALUES (29256, '500230206', '500230', '太平坝乡', '太平坝乡', '108.161659', '29.724747', 24);
INSERT INTO `street` VALUES (29257, '500230207', '500230', '都督乡', '都督乡', '108.123512', '29.627531', 4);
INSERT INTO `street` VALUES (29258, '500230209', '500230', '栗子乡', '栗子乡', '107.933266', '29.805513', 9);
INSERT INTO `street` VALUES (29259, '500230210', '500230', '三建乡', '三建乡', '107.865456', '29.80097', 17);
INSERT INTO `street` VALUES (29260, '500231100', '500231', '桂溪镇', '桂溪镇', '107.358917', '30.324675', 9);
INSERT INTO `street` VALUES (29261, '500231101', '500231', '新民镇', '新民镇', '107.39917', '30.392393', 20);
INSERT INTO `street` VALUES (29262, '500231102', '500231', '沙坪镇', '沙坪镇', '107.44635', '30.471655', 17);
INSERT INTO `street` VALUES (29263, '500231103', '500231', '周嘉镇', '周嘉镇', '107.547249', '30.412939', 25);
INSERT INTO `street` VALUES (29264, '500231104', '500231', '普顺镇', '普顺镇', '107.611626', '30.466892', 14);
INSERT INTO `street` VALUES (29265, '500231105', '500231', '永安镇', '永安镇', '107.521774', '30.347345', 22);
INSERT INTO `street` VALUES (29266, '500231106', '500231', '高安镇', '高安镇', '107.460541', '30.29215', 7);
INSERT INTO `street` VALUES (29267, '500231107', '500231', '高峰镇', '高峰镇', '107.417633', '30.214319', 8);
INSERT INTO `street` VALUES (29268, '500231108', '500231', '五洞镇', '五洞镇', '107.352859', '30.208504', 19);
INSERT INTO `street` VALUES (29269, '500231109', '500231', '澄溪镇', '澄溪镇', '107.268913', '30.204779', 4);
INSERT INTO `street` VALUES (29270, '500231110', '500231', '太平镇', '太平镇', '107.302254', '30.256618', 18);
INSERT INTO `street` VALUES (29271, '500231111', '500231', '鹤游镇', '鹤游镇', '107.367073', '30.0746', 10);
INSERT INTO `street` VALUES (29272, '500231112', '500231', '坪山镇', '坪山镇', '107.433571', '30.091478', 13);
INSERT INTO `street` VALUES (29273, '500231113', '500231', '砚台镇', '砚台镇', '107.32869', '30.141146', 21);
INSERT INTO `street` VALUES (29274, '500231114', '500231', '曹回镇', '曹回镇', '107.47937', '30.390511', 3);
INSERT INTO `street` VALUES (29275, '500231115', '500231', '杠家镇', '杠家镇', '107.348694', '30.330011', 6);
INSERT INTO `street` VALUES (29276, '500231116', '500231', '包家镇', '包家镇', '107.348694', '30.330011', 2);
INSERT INTO `street` VALUES (29277, '500231117', '500231', '白家镇', '白家镇', '107.348694', '30.330011', 1);
INSERT INTO `street` VALUES (29278, '500231118', '500231', '永平镇', '永平镇', '107.348694', '30.330011', 23);
INSERT INTO `street` VALUES (29279, '500231119', '500231', '三溪镇', '三溪镇', '107.348694', '30.330011', 15);
INSERT INTO `street` VALUES (29280, '500231120', '500231', '裴兴镇', '裴兴镇', '107.348694', '30.330011', 12);
INSERT INTO `street` VALUES (29281, '500231201', '500231', '长龙乡', '长龙乡', '107.42289', '30.301987', 24);
INSERT INTO `street` VALUES (29282, '500231202', '500231', '沙河乡', '沙河乡', '107.573715', '30.27594', 16);
INSERT INTO `street` VALUES (29283, '500231204', '500231', '大石乡', '大石乡', '107.545296', '30.194214', 5);
INSERT INTO `street` VALUES (29284, '500231205', '500231', '黄沙乡', '黄沙乡', '107.385155', '30.258268', 11);
INSERT INTO `street` VALUES (29285, '500232100', '500232', '巷口镇', '巷口镇', '107.764687', '29.326838', 21);
INSERT INTO `street` VALUES (29286, '500232101', '500232', '火炉镇', '火炉镇', '107.881393', '29.38883', 9);
INSERT INTO `street` VALUES (29287, '500232102', '500232', '白马镇', '白马镇', '107.544044', '29.397842', 1);
INSERT INTO `street` VALUES (29288, '500232103', '500232', '鸭江镇', '鸭江镇', '107.382614', '29.450014', 23);
INSERT INTO `street` VALUES (29289, '500232104', '500232', '长坝镇', '长坝镇', '107.484314', '29.326992', 25);
INSERT INTO `street` VALUES (29290, '500232105', '500232', '江口镇', '江口镇', '107.888611', '29.233162', 10);
INSERT INTO `street` VALUES (29291, '500232106', '500232', '平桥镇', '平桥镇', '107.34864', '29.367088', 13);
INSERT INTO `street` VALUES (29292, '500232107', '500232', '羊角镇', '羊角镇', '107.612724', '29.392328', 24);
INSERT INTO `street` VALUES (29293, '500232108', '500232', '仙女山镇', '仙女山镇', '107.767532', '29.427938', 22);
INSERT INTO `street` VALUES (29294, '500232109', '500232', '桐梓镇', '桐梓镇', '107.961716', '29.553509', 17);
INSERT INTO `street` VALUES (29295, '500232110', '500232', '土坎镇', '土坎镇', '107.686295', '29.371399', 19);
INSERT INTO `street` VALUES (29296, '500232111', '500232', '和顺镇', '和顺镇', '107.756554', '29.323759', 6);
INSERT INTO `street` VALUES (29297, '500232200', '500232', '凤来乡', '凤来乡', '107.305107', '29.394869', 4);
INSERT INTO `street` VALUES (29298, '500232202', '500232', '庙垭乡', '庙垭乡', '107.328293', '29.440138', 12);
INSERT INTO `street` VALUES (29299, '500232203', '500232', '石桥苗族土家族乡', '石桥苗族土家族乡', '107.756554', '29.323759', 14);
INSERT INTO `street` VALUES (29300, '500232204', '500232', '双河乡', '双河乡', '107.727699', '29.545269', 15);
INSERT INTO `street` VALUES (29301, '500232205', '500232', '黄莺乡', '黄莺乡', '107.696594', '29.21015', 8);
INSERT INTO `street` VALUES (29302, '500232206', '500232', '沧沟乡', '沧沟乡', '107.979286', '29.441977', 3);
INSERT INTO `street` VALUES (29303, '500232207', '500232', '文复苗族土家族乡', '文复苗族土家族乡', '107.756554', '29.323759', 20);
INSERT INTO `street` VALUES (29304, '500232208', '500232', '土地乡', '土地乡', '107.909737', '29.499573', 18);
INSERT INTO `street` VALUES (29305, '500232209', '500232', '白云乡', '白云乡', '107.428062', '29.307302', 2);
INSERT INTO `street` VALUES (29306, '500232210', '500232', '后坪苗族土家族乡', '后坪苗族土家族乡', '107.756554', '29.323759', 7);
INSERT INTO `street` VALUES (29307, '500232211', '500232', '浩口苗族仡佬族乡', '浩口苗族仡佬族乡', '107.756554', '29.323759', 5);
INSERT INTO `street` VALUES (29308, '500232212', '500232', '接龙乡', '接龙乡', '107.903938', '29.590132', 11);
INSERT INTO `street` VALUES (29309, '500232213', '500232', '赵家乡', '赵家乡', '107.561363', '29.263655', 26);
INSERT INTO `street` VALUES (29310, '500232214', '500232', '铁矿乡', '铁矿乡', '107.43856', '29.251394', 16);
INSERT INTO `street` VALUES (29311, '500233100', '500233', '忠州镇', '忠州镇', '108.041992', '30.29314', 28);
INSERT INTO `street` VALUES (29312, '500233101', '500233', '新生镇', '新生镇', '107.951416', '30.207212', 24);
INSERT INTO `street` VALUES (29313, '500233102', '500233', '任家镇', '任家镇', '107.883514', '30.137463', 12);
INSERT INTO `street` VALUES (29314, '500233103', '500233', '乌杨镇', '乌杨镇', '108.007324', '30.198685', 21);
INSERT INTO `street` VALUES (29315, '500233104', '500233', '洋渡镇', '洋渡镇', '107.933113', '30.126322', 25);
INSERT INTO `street` VALUES (29316, '500233105', '500233', '东溪镇', '东溪镇', '108.071243', '30.256069', 3);
INSERT INTO `street` VALUES (29317, '500233106', '500233', '复兴镇', '复兴镇', '108.131325', '30.289551', 4);
INSERT INTO `street` VALUES (29318, '500233107', '500233', '石宝镇', '石宝镇', '108.193222', '30.416452', 16);
INSERT INTO `street` VALUES (29319, '500233108', '500233', '汝溪镇', '汝溪镇', '108.081444', '30.493599', 13);
INSERT INTO `street` VALUES (29320, '500233109', '500233', '野鹤镇', '野鹤镇', '108.132324', '30.519245', 26);
INSERT INTO `street` VALUES (29321, '500233110', '500233', '官坝镇', '官坝镇', '107.889633', '30.483385', 5);
INSERT INTO `street` VALUES (29322, '500233111', '500233', '石黄镇', '石黄镇', '107.854294', '30.505957', 17);
INSERT INTO `street` VALUES (29323, '500233112', '500233', '马灌镇', '马灌镇', '107.745331', '30.388901', 10);
INSERT INTO `street` VALUES (29324, '500233113', '500233', '金鸡镇', '金鸡镇', '107.738045', '30.471327', 8);
INSERT INTO `street` VALUES (29325, '500233114', '500233', '新立镇', '新立镇', '107.654427', '30.275484', 23);
INSERT INTO `street` VALUES (29326, '500233115', '500233', '双桂镇', '双桂镇', '107.597382', '30.237423', 19);
INSERT INTO `street` VALUES (29327, '500233116', '500233', '拔山镇', '拔山镇', '107.727585', '30.298805', 2);
INSERT INTO `street` VALUES (29328, '500233117', '500233', '花桥镇', '花桥镇', '107.703438', '30.355518', 7);
INSERT INTO `street` VALUES (29329, '500233118', '500233', '永丰镇', '永丰镇', '107.828133', '30.31262', 27);
INSERT INTO `street` VALUES (29330, '500233119', '500233', '三汇镇', '三汇镇', '107.877388', '30.375673', 14);
INSERT INTO `street` VALUES (29331, '500233120', '500233', '白石镇', '白石镇', '107.89035', '30.311249', 1);
INSERT INTO `street` VALUES (29332, '500233122', '500233', '黄金镇', '黄金镇', '108.006828', '30.368532', 6);
INSERT INTO `street` VALUES (29333, '500233201', '500233', '善广乡', '善广乡', '107.846596', '30.201275', 15);
INSERT INTO `street` VALUES (29334, '500233203', '500233', '石子乡', '石子乡', '108.057877', '30.107681', 18);
INSERT INTO `street` VALUES (29335, '500233204', '500233', '磨子土家族乡', '磨子土家族乡', '108.037521', '30.291536', 11);
INSERT INTO `street` VALUES (29336, '500233206', '500233', '涂井乡', '涂井乡', '108.129807', '30.437929', 20);
INSERT INTO `street` VALUES (29337, '500233208', '500233', '金声乡', '金声乡', '107.998436', '30.520052', 9);
INSERT INTO `street` VALUES (29338, '500233210', '500233', '兴峰乡', '兴峰乡', '107.968315', '30.46364', 22);
INSERT INTO `street` VALUES (29339, '500234002', '500234', '镇东街道', '镇东街道', '108.402634', '31.184511', 37);
INSERT INTO `street` VALUES (29340, '500234003', '500234', '丰乐街道', '丰乐街道', '108.426735', '31.192572', 7);
INSERT INTO `street` VALUES (29341, '500234004', '500234', '白鹤街道', '白鹤街道', '108.469116', '31.267994', 1);
INSERT INTO `street` VALUES (29342, '500234005', '500234', '汉丰街道', '汉丰街道', '108.419411', '31.187214', 11);
INSERT INTO `street` VALUES (29343, '500234006', '500234', '文峰街道', '文峰街道', '108.413315', '31.167734', 27);
INSERT INTO `street` VALUES (29344, '500234007', '500234', '云枫街道', '云枫街道', '108.413315', '31.167734', 33);
INSERT INTO `street` VALUES (29345, '500234008', '500234', '赵家街道', '赵家街道', '108.413315', '31.167734', 35);
INSERT INTO `street` VALUES (29346, '500234103', '500234', '郭家镇', '郭家镇', '108.484146', '31.292631', 10);
INSERT INTO `street` VALUES (29347, '500234106', '500234', '温泉镇', '温泉镇', '108.520912', '31.364042', 28);
INSERT INTO `street` VALUES (29348, '500234107', '500234', '铁桥镇', '铁桥镇', '108.136795', '31.035074', 26);
INSERT INTO `street` VALUES (29349, '500234112', '500234', '南雅镇', '南雅镇', '108.095505', '31.078995', 21);
INSERT INTO `street` VALUES (29350, '500234114', '500234', '和谦镇', '和谦镇', '108.472893', '31.411848', 12);
INSERT INTO `street` VALUES (29351, '500234116', '500234', '镇安镇', '镇安镇', '108.318939', '31.148907', 36);
INSERT INTO `street` VALUES (29352, '500234118', '500234', '竹溪镇', '竹溪镇', '108.300522', '31.122255', 39);
INSERT INTO `street` VALUES (29353, '500234119', '500234', '渠口镇', '渠口镇', '108.489105', '31.134237', 22);
INSERT INTO `street` VALUES (29354, '500234120', '500234', '厚坝镇', '厚坝镇', '108.487091', '31.199003', 14);
INSERT INTO `street` VALUES (29355, '500234122', '500234', '高桥镇', '高桥镇', '108.249512', '31.364902', 8);
INSERT INTO `street` VALUES (29356, '500234127', '500234', '义和镇', '义和镇', '108.093399', '31.154356', 31);
INSERT INTO `street` VALUES (29357, '500234128', '500234', '大进镇', '大进镇', '108.455078', '31.50667', 5);
INSERT INTO `street` VALUES (29358, '500234129', '500234', '长沙镇', '长沙镇', '108.334869', '30.992828', 34);
INSERT INTO `street` VALUES (29359, '500234130', '500234', '临江镇', '临江镇', '108.227692', '31.098412', 17);
INSERT INTO `street` VALUES (29360, '500234132', '500234', '敦好镇', '敦好镇', '108.377449', '31.333431', 6);
INSERT INTO `street` VALUES (29361, '500234133', '500234', '中和镇', '中和镇', '108.135048', '31.17634', 38);
INSERT INTO `street` VALUES (29362, '500234134', '500234', '岳溪镇', '岳溪镇', '108.170258', '30.906616', 32);
INSERT INTO `street` VALUES (29363, '500234135', '500234', '南门镇', '南门镇', '108.248108', '30.965666', 20);
INSERT INTO `street` VALUES (29364, '500234136', '500234', '河堰镇', '河堰镇', '108.67878', '31.350534', 13);
INSERT INTO `street` VALUES (29365, '500234137', '500234', '九龙山镇', '九龙山镇', '108.257729', '31.184364', 16);
INSERT INTO `street` VALUES (29366, '500234138', '500234', '白桥镇', '白桥镇', '108.413315', '31.167734', 2);
INSERT INTO `street` VALUES (29367, '500234139', '500234', '天和镇', '天和镇', '108.413315', '31.167734', 25);
INSERT INTO `street` VALUES (29368, '500234140', '500234', '金峰镇', '金峰镇', '108.413315', '31.167734', 15);
INSERT INTO `street` VALUES (29369, '500234141', '500234', '谭家镇', '谭家镇', '108.413315', '31.167734', 24);
INSERT INTO `street` VALUES (29370, '500234142', '500234', '巫山镇', '巫山镇', '107.95034', '30.933567', 29);
INSERT INTO `street` VALUES (29371, '500234143', '500234', '大德镇', '大德镇', '108.413315', '31.167734', 4);
INSERT INTO `street` VALUES (29372, '500234202', '500234', '白泉乡', '白泉乡', '108.793541', '31.592392', 3);
INSERT INTO `street` VALUES (29373, '500234203', '500234', '关面乡', '关面乡', '108.681541', '31.54788', 9);
INSERT INTO `street` VALUES (29374, '500234204', '500234', '满月乡', '满月乡', '108.575211', '31.615501', 19);
INSERT INTO `street` VALUES (29375, '500234211', '500234', '五通乡', '五通乡', '108.066856', '30.886028', 30);
INSERT INTO `street` VALUES (29376, '500234215', '500234', '麻柳乡', '麻柳乡', '108.252625', '31.429567', 18);
INSERT INTO `street` VALUES (29377, '500234216', '500234', '紫水乡', '紫水乡', '108.324081', '31.407255', 40);
INSERT INTO `street` VALUES (29378, '500234225', '500234', '三汇口乡', '三汇口乡', '108.107986', '31.247599', 23);
INSERT INTO `street` VALUES (29379, '500235001', '500235', '双江街道', '双江街道', '108.697701', '30.930529', 31);
INSERT INTO `street` VALUES (29380, '500235002', '500235', '青龙街道', '青龙街道', '108.697701', '30.930529', 22);
INSERT INTO `street` VALUES (29381, '500235003', '500235', '人和街道', '人和街道', '108.697701', '30.930529', 26);
INSERT INTO `street` VALUES (29382, '500235004', '500235', '盘龙街道', '盘龙街道', '108.697701', '30.930529', 18);
INSERT INTO `street` VALUES (29383, '500235105', '500235', '龙角镇', '龙角镇', '108.863747', '30.809999', 13);
INSERT INTO `street` VALUES (29384, '500235107', '500235', '故陵镇', '故陵镇', '109.091125', '30.938992', 7);
INSERT INTO `street` VALUES (29385, '500235108', '500235', '红狮镇', '红狮镇', '109.03392', '30.984013', 8);
INSERT INTO `street` VALUES (29386, '500235115', '500235', '路阳镇', '路阳镇', '108.700638', '31.232788', 14);
INSERT INTO `street` VALUES (29387, '500235116', '500235', '农坝镇', '农坝镇', '108.745384', '31.371008', 17);
INSERT INTO `street` VALUES (29388, '500235118', '500235', '渠马镇', '渠马镇', '108.615356', '31.13205', 25);
INSERT INTO `street` VALUES (29389, '500235121', '500235', '黄石镇', '黄石镇', '108.722214', '30.997982', 10);
INSERT INTO `street` VALUES (29390, '500235122', '500235', '巴阳镇', '巴阳镇', '108.574059', '30.948906', 2);
INSERT INTO `street` VALUES (29391, '500235123', '500235', '沙市镇', '沙市镇', '108.891556', '31.330881', 29);
INSERT INTO `street` VALUES (29392, '500235124', '500235', '鱼泉镇', '鱼泉镇', '108.851341', '31.285053', 42);
INSERT INTO `street` VALUES (29393, '500235125', '500235', '凤鸣镇', '凤鸣镇', '108.76284', '30.863314', 5);
INSERT INTO `street` VALUES (29394, '500235127', '500235', '宝坪镇', '宝坪镇', '108.85981', '30.878609', 1);
INSERT INTO `street` VALUES (29395, '500235128', '500235', '南溪镇', '南溪镇', '108.843803', '31.118048', 15);
INSERT INTO `street` VALUES (29396, '500235129', '500235', '双土镇', '双土镇', '108.939056', '31.156794', 33);
INSERT INTO `street` VALUES (29397, '500235130', '500235', '桑坪镇', '桑坪镇', '109.049088', '31.216051', 27);
INSERT INTO `street` VALUES (29398, '500235131', '500235', '江口镇', '江口镇', '108.80265', '31.216227', 11);
INSERT INTO `street` VALUES (29399, '500235132', '500235', '高阳镇', '高阳镇', '108.68148', '31.095795', 6);
INSERT INTO `street` VALUES (29400, '500235133', '500235', '平安镇', '平安镇', '108.697701', '30.930529', 20);
INSERT INTO `street` VALUES (29401, '500235135', '500235', '云阳镇', '云阳镇', '108.895164', '30.960449', 41);
INSERT INTO `street` VALUES (29402, '500235136', '500235', '云安镇', '云安镇', '108.853035', '31.05505', 40);
INSERT INTO `street` VALUES (29403, '500235137', '500235', '栖霞镇', '栖霞镇', '108.697701', '30.930529', 24);
INSERT INTO `street` VALUES (29404, '500235138', '500235', '双龙镇', '双龙镇', '108.697701', '30.930529', 32);
INSERT INTO `street` VALUES (29405, '500235139', '500235', '泥溪镇', '泥溪镇', '108.697701', '30.930529', 16);
INSERT INTO `street` VALUES (29406, '500235140', '500235', '票草镇', '票草镇', '108.697701', '30.930529', 19);
INSERT INTO `street` VALUES (29407, '500235141', '500235', '养鹿镇', '养鹿镇', '108.697701', '30.930529', 37);
INSERT INTO `street` VALUES (29408, '500235142', '500235', '水口镇', '水口镇', '108.697701', '30.930529', 34);
INSERT INTO `street` VALUES (29409, '500235143', '500235', '堰坪镇', '堰坪镇', '108.697701', '30.930529', 38);
INSERT INTO `street` VALUES (29410, '500235144', '500235', '龙洞镇', '龙洞镇', '108.697701', '30.930529', 12);
INSERT INTO `street` VALUES (29411, '500235145', '500235', '后叶镇', '后叶镇', '108.697701', '30.930529', 9);
INSERT INTO `street` VALUES (29412, '500235208', '500235', '外郎乡', '外郎乡', '108.773376', '30.782663', 35);
INSERT INTO `street` VALUES (29413, '500235210', '500235', '耀灵乡', '耀灵乡', '108.90638', '30.648478', 39);
INSERT INTO `street` VALUES (29414, '500235215', '500235', '新津乡', '新津乡', '108.949699', '30.928778', 36);
INSERT INTO `street` VALUES (29415, '500235216', '500235', '普安乡', '普安乡', '108.934097', '30.86413', 21);
INSERT INTO `street` VALUES (29416, '500235218', '500235', '洞鹿乡', '洞鹿乡', '109.043205', '31.081379', 4);
INSERT INTO `street` VALUES (29417, '500235219', '500235', '石门乡', '石门乡', '109.041672', '31.129827', 30);
INSERT INTO `street` VALUES (29418, '500235220', '500235', '大阳乡', '大阳乡', '109.014488', '31.15333', 3);
INSERT INTO `street` VALUES (29419, '500235239', '500235', '上坝乡', '上坝乡', '108.912788', '31.366753', 28);
INSERT INTO `street` VALUES (29420, '500235242', '500235', '清水土家族自治乡', '清水土家族自治乡', '108.697701', '30.930529', 23);
INSERT INTO `street` VALUES (29421, '500236116', '500236', '永安镇', '永安镇', '109.590485', '30.709482', 26);
INSERT INTO `street` VALUES (29422, '500236117', '500236', '白帝镇', '白帝镇', '109.590218', '31.056797', 3);
INSERT INTO `street` VALUES (29423, '500236118', '500236', '草堂镇', '草堂镇', '109.657326', '31.096102', 4);
INSERT INTO `street` VALUES (29424, '500236119', '500236', '汾河镇', '汾河镇', '109.553825', '31.165136', 7);
INSERT INTO `street` VALUES (29425, '500236120', '500236', '康乐镇', '康乐镇', '109.435371', '31.116407', 12);
INSERT INTO `street` VALUES (29426, '500236121', '500236', '大树镇', '大树镇', '109.331245', '31.206062', 5);
INSERT INTO `street` VALUES (29427, '500236122', '500236', '竹园镇', '竹园镇', '109.26973', '31.297089', 31);
INSERT INTO `street` VALUES (29428, '500236123', '500236', '公平镇', '公平镇', '109.228859', '31.115263', 8);
INSERT INTO `street` VALUES (29429, '500236124', '500236', '朱衣镇', '朱衣镇', '109.363594', '31.038734', 30);
INSERT INTO `street` VALUES (29430, '500236125', '500236', '甲高镇', '甲高镇', '109.189697', '30.891499', 11);
INSERT INTO `street` VALUES (29431, '500236126', '500236', '羊市镇', '羊市镇', '109.053261', '30.817575', 24);
INSERT INTO `street` VALUES (29432, '500236127', '500236', '吐祥镇', '吐祥镇', '109.163353', '30.70801', 20);
INSERT INTO `street` VALUES (29433, '500236128', '500236', '兴隆镇', '兴隆镇', '109.455269', '30.653818', 22);
INSERT INTO `street` VALUES (29434, '500236129', '500236', '青龙镇', '青龙镇', '109.286873', '30.774076', 17);
INSERT INTO `street` VALUES (29435, '500236130', '500236', '新民镇', '新民镇', '109.474648', '30.896446', 23);
INSERT INTO `street` VALUES (29436, '500236131', '500236', '永乐镇', '永乐镇', '109.54818', '30.983885', 27);
INSERT INTO `street` VALUES (29437, '500236132', '500236', '安坪镇', '安坪镇', '109.465775', '31.019966', 1);
INSERT INTO `street` VALUES (29438, '500236133', '500236', '五马镇', '五马镇', '109.465775', '31.019966', 21);
INSERT INTO `street` VALUES (29439, '500236134', '500236', '青莲镇', '青莲镇', '109.465775', '31.019966', 16);
INSERT INTO `street` VALUES (29440, '500236265', '500236', '岩湾乡', '岩湾乡', '109.531738', '31.234774', 25);
INSERT INTO `street` VALUES (29441, '500236266', '500236', '平安乡', '平安乡', '109.172508', '31.344692', 15);
INSERT INTO `street` VALUES (29442, '500236267', '500236', '红土乡', '红土乡', '109.160652', '31.108845', 10);
INSERT INTO `street` VALUES (29443, '500236269', '500236', '石岗乡', '石岗乡', '109.312195', '31.134769', 18);
INSERT INTO `street` VALUES (29444, '500236270', '500236', '康坪乡', '康坪乡', '109.239243', '30.981827', 13);
INSERT INTO `street` VALUES (29445, '500236272', '500236', '太和土家族乡', '太和土家族乡', '109.465775', '31.019966', 19);
INSERT INTO `street` VALUES (29446, '500236274', '500236', '鹤峰乡', '鹤峰乡', '109.517578', '30.883947', 9);
INSERT INTO `street` VALUES (29447, '500236275', '500236', '冯坪乡', '冯坪乡', '109.51812', '30.831511', 6);
INSERT INTO `street` VALUES (29448, '500236276', '500236', '长安土家族乡', '长安土家族乡', '109.563126', '30.828094', 29);
INSERT INTO `street` VALUES (29449, '500236277', '500236', '龙桥土家族乡', '龙桥土家族乡', '109.369125', '30.613081', 14);
INSERT INTO `street` VALUES (29450, '500236278', '500236', '云雾土家族乡', '云雾土家族乡', '109.135994', '30.598663', 28);
INSERT INTO `street` VALUES (29451, '500236400', '500236', '白帝城风景区管理委员会', '白帝城风景区管理委员会', '109.590218', '31.056797', 2);
INSERT INTO `street` VALUES (29452, '500237001', '500237', '高唐街道', '高唐街道', '109.878929', '31.074842', 8);
INSERT INTO `street` VALUES (29453, '500237002', '500237', '龙门街道', '龙门街道', '109.878929', '31.074842', 15);
INSERT INTO `street` VALUES (29454, '500237101', '500237', '庙宇镇', '庙宇镇', '109.65464', '30.857082', 18);
INSERT INTO `street` VALUES (29455, '500237102', '500237', '大昌镇', '大昌镇', '109.806274', '31.262228', 2);
INSERT INTO `street` VALUES (29456, '500237103', '500237', '福田镇', '福田镇', '109.719833', '31.216139', 7);
INSERT INTO `street` VALUES (29457, '500237104', '500237', '龙溪镇', '龙溪镇', '109.645691', '31.301237', 16);
INSERT INTO `street` VALUES (29458, '500237105', '500237', '双龙镇', '双龙镇', '109.886314', '31.189981', 23);
INSERT INTO `street` VALUES (29459, '500237106', '500237', '官阳镇', '官阳镇', '109.908333', '31.337948', 10);
INSERT INTO `street` VALUES (29460, '500237107', '500237', '骡坪镇', '骡坪镇', '110.097', '31.202047', 17);
INSERT INTO `street` VALUES (29461, '500237108', '500237', '抱龙镇', '抱龙镇', '109.980476', '30.9375', 1);
INSERT INTO `street` VALUES (29462, '500237109', '500237', '官渡镇', '官渡镇', '109.857391', '30.950466', 9);
INSERT INTO `street` VALUES (29463, '500237110', '500237', '铜鼓镇', '铜鼓镇', '109.742767', '30.930696', 24);
INSERT INTO `street` VALUES (29464, '500237111', '500237', '巫峡镇', '巫峡镇', '109.87915', '31.072948', 25);
INSERT INTO `street` VALUES (29465, '500237200', '500237', '红椿乡', '红椿乡', '109.722816', '30.846943', 11);
INSERT INTO `street` VALUES (29466, '500237207', '500237', '两坪乡', '两坪乡', '109.976929', '31.115906', 14);
INSERT INTO `street` VALUES (29467, '500237208', '500237', '曲尺乡', '曲尺乡', '109.750702', '31.036716', 21);
INSERT INTO `street` VALUES (29468, '500237210', '500237', '建坪乡', '建坪乡', '109.929359', '31.0443', 12);
INSERT INTO `street` VALUES (29469, '500237211', '500237', '大溪乡', '大溪乡', '109.642365', '30.996046', 4);
INSERT INTO `street` VALUES (29470, '500237214', '500237', '金坪乡', '金坪乡', '109.947594', '31.203695', 13);
INSERT INTO `street` VALUES (29471, '500237216', '500237', '平河乡', '平河乡', '109.957359', '31.256086', 20);
INSERT INTO `street` VALUES (29472, '500237219', '500237', '当阳乡', '当阳乡', '109.983101', '31.396702', 3);
INSERT INTO `street` VALUES (29473, '500237222', '500237', '竹贤乡', '竹贤乡', '110.081017', '31.279222', 26);
INSERT INTO `street` VALUES (29474, '500237225', '500237', '三溪乡', '三溪乡', '110.108826', '31.128021', 22);
INSERT INTO `street` VALUES (29475, '500237227', '500237', '培石乡', '培石乡', '110.103676', '31.003729', 19);
INSERT INTO `street` VALUES (29476, '500237229', '500237', '笃坪乡', '笃坪乡', '110.115288', '30.929499', 6);
INSERT INTO `street` VALUES (29477, '500237231', '500237', '邓家乡', '邓家乡', '110.062302', '30.838182', 5);
INSERT INTO `street` VALUES (29478, '500238001', '500238', '宁河街道', '宁河街道', '109.628914', '31.396601', 15);
INSERT INTO `street` VALUES (29479, '500238002', '500238', '柏杨街道', '柏杨街道', '109.628914', '31.396601', 2);
INSERT INTO `street` VALUES (29480, '500238100', '500238', '城厢镇', '城厢镇', '109.627975', '31.39715', 4);
INSERT INTO `street` VALUES (29481, '500238101', '500238', '凤凰镇', '凤凰镇', '109.523499', '31.396885', 6);
INSERT INTO `street` VALUES (29482, '500238102', '500238', '宁厂镇', '宁厂镇', '109.625443', '31.458857', 14);
INSERT INTO `street` VALUES (29483, '500238103', '500238', '上磺镇', '上磺镇', '109.487701', '31.317247', 17);
INSERT INTO `street` VALUES (29484, '500238104', '500238', '古路镇', '古路镇', '109.449471', '31.326481', 8);
INSERT INTO `street` VALUES (29485, '500238105', '500238', '文峰镇', '文峰镇', '109.246117', '31.401022', 26);
INSERT INTO `street` VALUES (29486, '500238106', '500238', '徐家镇', '徐家镇', '109.681343', '31.637318', 29);
INSERT INTO `street` VALUES (29487, '500238107', '500238', '白鹿镇', '白鹿镇', '109.684921', '31.604496', 1);
INSERT INTO `street` VALUES (29488, '500238108', '500238', '尖山镇', '尖山镇', '108.904373', '31.429403', 11);
INSERT INTO `street` VALUES (29489, '500238109', '500238', '下堡镇', '下堡镇', '109.526306', '31.571892', 28);
INSERT INTO `street` VALUES (29490, '500238110', '500238', '峰灵镇', '峰灵镇', '109.628914', '31.396601', 7);
INSERT INTO `street` VALUES (29491, '500238111', '500238', '塘坊镇', '塘坊镇', '109.628914', '31.396601', 20);
INSERT INTO `street` VALUES (29492, '500238112', '500238', '朝阳镇', '朝阳镇', '109.628914', '31.396601', 3);
INSERT INTO `street` VALUES (29493, '500238113', '500238', '田坝镇', '田坝镇', '110.169777', '32.166031', 21);
INSERT INTO `street` VALUES (29494, '500238114', '500238', '通城镇', '通城镇', '109.628914', '31.396601', 24);
INSERT INTO `street` VALUES (29495, '500238204', '500238', '胜利乡', '胜利乡', '109.454163', '31.430559', 18);
INSERT INTO `street` VALUES (29496, '500238205', '500238', '菱角乡', '菱角乡', '109.427597', '31.391123', 13);
INSERT INTO `street` VALUES (29497, '500238207', '500238', '大河乡', '大河乡', '109.630798', '31.4984', 5);
INSERT INTO `street` VALUES (29498, '500238208', '500238', '天星乡', '天星乡', '109.551468', '31.465612', 22);
INSERT INTO `street` VALUES (29499, '500238210', '500238', '长桂乡', '长桂乡', '109.380035', '31.48971', 31);
INSERT INTO `street` VALUES (29500, '500238212', '500238', '蒲莲乡', '蒲莲乡', '109.569763', '31.29179', 16);
INSERT INTO `street` VALUES (29501, '500238226', '500238', '鱼鳞乡', '鱼鳞乡', '109.496613', '31.671919', 30);
INSERT INTO `street` VALUES (29502, '500238227', '500238', '乌龙乡', '乌龙乡', '109.44767', '31.650818', 27);
INSERT INTO `street` VALUES (29503, '500238234', '500238', '中岗乡', '中岗乡', '108.853188', '31.528282', 32);
INSERT INTO `street` VALUES (29504, '500238237', '500238', '花台乡', '花台乡', '109.6558', '31.302132', 10);
INSERT INTO `street` VALUES (29505, '500238239', '500238', '兰英乡', '兰英乡', '109.816025', '31.42013', 12);
INSERT INTO `street` VALUES (29506, '500238240', '500238', '双阳乡', '双阳乡', '109.831497', '31.471399', 19);
INSERT INTO `street` VALUES (29507, '500238242', '500238', '中梁乡', '中梁乡', '109.350922', '31.586658', 33);
INSERT INTO `street` VALUES (29508, '500238243', '500238', '天元乡', '天元乡', '109.210365', '31.583771', 23);
INSERT INTO `street` VALUES (29509, '500238245', '500238', '土城乡', '土城乡', '109.235336', '31.630371', 25);
INSERT INTO `street` VALUES (29510, '500238400', '500238', '红池坝经济开发区', '红池坝经济开发区', '109.628914', '31.396601', 9);
INSERT INTO `street` VALUES (29511, '500240100', '500240', '南宾镇', '南宾镇', '108.116478', '29.997196', 15);
INSERT INTO `street` VALUES (29512, '500240101', '500240', '西沱镇', '西沱镇', '108.227226', '30.403175', 27);
INSERT INTO `street` VALUES (29513, '500240102', '500240', '下路镇', '下路镇', '108.094803', '29.937614', 25);
INSERT INTO `street` VALUES (29514, '500240103', '500240', '悦崃镇', '悦崃镇', '108.273125', '30.202137', 31);
INSERT INTO `street` VALUES (29515, '500240104', '500240', '临溪镇', '临溪镇', '108.360291', '30.401169', 10);
INSERT INTO `street` VALUES (29516, '500240105', '500240', '黄水镇', '黄水镇', '108.397552', '30.23731', 5);
INSERT INTO `street` VALUES (29517, '500240106', '500240', '马武镇', '马武镇', '108.353523', '29.782076', 14);
INSERT INTO `street` VALUES (29518, '500240107', '500240', '沙子镇', '沙子镇', '108.415176', '30.022289', 20);
INSERT INTO `street` VALUES (29519, '500240108', '500240', '王场镇', '王场镇', '108.190849', '30.318533', 23);
INSERT INTO `street` VALUES (29520, '500240109', '500240', '沿溪镇', '沿溪镇', '108.132477', '30.295361', 29);
INSERT INTO `street` VALUES (29521, '500240110', '500240', '龙沙镇', '龙沙镇', '108.193581', '30.129999', 12);
INSERT INTO `street` VALUES (29522, '500240111', '500240', '鱼池镇', '鱼池镇', '108.229958', '30.260252', 30);
INSERT INTO `street` VALUES (29523, '500240112', '500240', '三河镇', '三河镇', '108.11245', '29.998529', 17);
INSERT INTO `street` VALUES (29524, '500240113', '500240', '大歇镇', '大歇镇', '108.113441', '30.069113', 1);
INSERT INTO `street` VALUES (29525, '500240114', '500240', '桥头镇', '桥头镇', '108.11245', '29.998529', 16);
INSERT INTO `street` VALUES (29526, '500240115', '500240', '万朝镇', '万朝镇', '108.11245', '29.998529', 22);
INSERT INTO `street` VALUES (29527, '500240116', '500240', '冷水镇', '冷水镇', '108.11245', '29.998529', 8);
INSERT INTO `street` VALUES (29528, '500240203', '500240', '黎场乡', '黎场乡', '108.1502', '30.344639', 9);
INSERT INTO `street` VALUES (29529, '500240204', '500240', '三星乡', '三星乡', '108.11824', '29.888973', 18);
INSERT INTO `street` VALUES (29530, '500240205', '500240', '六塘乡', '六塘乡', '108.277206', '29.931652', 11);
INSERT INTO `street` VALUES (29531, '500240207', '500240', '三益乡', '三益乡', '108.285622', '30.142487', 19);
INSERT INTO `street` VALUES (29532, '500240208', '500240', '王家乡', '王家乡', '108.321365', '30.341906', 24);
INSERT INTO `street` VALUES (29533, '500240209', '500240', '河嘴乡', '河嘴乡', '108.407318', '30.508993', 3);
INSERT INTO `street` VALUES (29534, '500240210', '500240', '石家乡', '石家乡', '108.334251', '30.280005', 21);
INSERT INTO `street` VALUES (29535, '500240212', '500240', '枫木乡', '枫木乡', '108.494453', '30.245491', 2);
INSERT INTO `street` VALUES (29536, '500240213', '500240', '中益乡', '中益乡', '108.339333', '30.089144', 32);
INSERT INTO `street` VALUES (29537, '500240214', '500240', '洗新乡', '洗新乡', '108.402115', '29.909395', 28);
INSERT INTO `street` VALUES (29538, '500240215', '500240', '黄鹤乡', '黄鹤乡', '108.37188', '29.815681', 4);
INSERT INTO `street` VALUES (29539, '500240216', '500240', '龙潭乡', '龙潭乡', '108.270821', '29.836834', 13);
INSERT INTO `street` VALUES (29540, '500240217', '500240', '新乐乡', '新乐乡', '108.475815', '29.922119', 26);
INSERT INTO `street` VALUES (29541, '500240218', '500240', '金铃乡', '金铃乡', '108.504005', '29.984499', 6);
INSERT INTO `street` VALUES (29542, '500240219', '500240', '金竹乡', '金竹乡', '108.464645', '29.957731', 7);
INSERT INTO `street` VALUES (29543, '500241001', '500241', '中和街道', '中和街道', '108.995163', '28.451805', 25);
INSERT INTO `street` VALUES (29544, '500241002', '500241', '乌杨街道', '乌杨街道', '108.99604', '28.444773', 20);
INSERT INTO `street` VALUES (29545, '500241003', '500241', '平凯街道', '平凯街道', '108.99604', '28.444773', 14);
INSERT INTO `street` VALUES (29546, '500241102', '500241', '清溪场镇', '清溪场镇', '108.915398', '28.406042', 15);
INSERT INTO `street` VALUES (29547, '500241103', '500241', '隘口镇', '隘口镇', '108.806381', '28.326015', 1);
INSERT INTO `street` VALUES (29548, '500241104', '500241', '溶溪镇', '溶溪镇', '108.88929', '28.518126', 16);
INSERT INTO `street` VALUES (29549, '500241105', '500241', '官庄镇', '官庄镇', '109.01973', '28.500963', 6);
INSERT INTO `street` VALUES (29550, '500241106', '500241', '龙池镇', '龙池镇', '109.057976', '28.604849', 11);
INSERT INTO `street` VALUES (29551, '500241107', '500241', '石堤镇', '石堤镇', '109.201614', '28.746391', 17);
INSERT INTO `street` VALUES (29552, '500241108', '500241', '峨溶镇', '峨溶镇', '109.243233', '28.567778', 4);
INSERT INTO `street` VALUES (29553, '500241109', '500241', '洪安镇', '洪安镇', '109.268852', '28.496252', 8);
INSERT INTO `street` VALUES (29554, '500241110', '500241', '雅江镇', '雅江镇', '109.181633', '28.455326', 23);
INSERT INTO `street` VALUES (29555, '500241111', '500241', '石耶镇', '石耶镇', '109.066956', '28.375036', 18);
INSERT INTO `street` VALUES (29556, '500241112', '500241', '梅江镇', '梅江镇', '109.0373', '28.256794', 12);
INSERT INTO `street` VALUES (29557, '500241113', '500241', '兰桥镇', '兰桥镇', '109.003937', '28.180805', 9);
INSERT INTO `street` VALUES (29558, '500241114', '500241', '膏田镇', '膏田镇', '108.99604', '28.444773', 5);
INSERT INTO `street` VALUES (29559, '500241115', '500241', '溪口镇', '溪口镇', '108.99604', '28.444773', 22);
INSERT INTO `street` VALUES (29560, '500241116', '500241', '妙泉镇', '妙泉镇', '108.99604', '28.444773', 13);
INSERT INTO `street` VALUES (29561, '500241117', '500241', '宋农镇', '宋农镇', '108.99604', '28.444773', 19);
INSERT INTO `street` VALUES (29562, '500241118', '500241', '里仁镇', '里仁镇', '108.99604', '28.444773', 10);
INSERT INTO `street` VALUES (29563, '500241119', '500241', '钟灵镇', '钟灵镇', '108.99604', '28.444773', 26);
INSERT INTO `street` VALUES (29564, '500241201', '500241', '孝溪乡', '孝溪乡', '108.91832', '28.371725', 21);
INSERT INTO `street` VALUES (29565, '500241207', '500241', '海洋乡', '海洋乡', '109.127151', '28.728872', 7);
INSERT INTO `street` VALUES (29566, '500241208', '500241', '大溪乡', '大溪乡', '109.17556', '28.790232', 3);
INSERT INTO `street` VALUES (29567, '500241211', '500241', '涌洞乡', '涌洞乡', '109.112953', '28.601978', 24);
INSERT INTO `street` VALUES (29568, '500241214', '500241', '中平乡', '中平乡', '109.13279', '28.413479', 27);
INSERT INTO `street` VALUES (29569, '500241215', '500241', '岑溪乡', '岑溪乡', '108.99604', '28.444773', 2);
INSERT INTO `street` VALUES (29570, '500242100', '500242', '桃花源镇', '桃花源镇', '108.767204', '28.839828', 27);
INSERT INTO `street` VALUES (29571, '500242101', '500242', '龙潭镇', '龙潭镇', '108.966881', '28.757307', 17);
INSERT INTO `street` VALUES (29572, '500242102', '500242', '麻旺镇', '麻旺镇', '108.9599', '28.887024', 19);
INSERT INTO `street` VALUES (29573, '500242103', '500242', '酉酬镇', '酉酬镇', '109.150848', '28.957666', 36);
INSERT INTO `street` VALUES (29574, '500242104', '500242', '大溪镇', '大溪镇', '109.161247', '29.090899', 5);
INSERT INTO `street` VALUES (29575, '500242105', '500242', '兴隆镇', '兴隆镇', '109.048515', '29.253469', 34);
INSERT INTO `street` VALUES (29576, '500242106', '500242', '黑水镇', '黑水镇', '108.807076', '29.047323', 10);
INSERT INTO `street` VALUES (29577, '500242107', '500242', '丁市镇', '丁市镇', '108.553619', '28.769518', 6);
INSERT INTO `street` VALUES (29578, '500242108', '500242', '龚滩镇', '龚滩镇', '108.356651', '28.903427', 8);
INSERT INTO `street` VALUES (29579, '500242109', '500242', '李溪镇', '李溪镇', '108.618271', '28.523315', 16);
INSERT INTO `street` VALUES (29580, '500242110', '500242', '泔溪镇', '泔溪镇', '108.968605', '28.976044', 7);
INSERT INTO `street` VALUES (29581, '500242111', '500242', '酉水河镇', '酉水河镇', '108.767204', '28.839828', 37);
INSERT INTO `street` VALUES (29582, '500242112', '500242', '苍岭镇', '苍岭镇', '108.597069', '29.006968', 3);
INSERT INTO `street` VALUES (29583, '500242113', '500242', '小河镇', '小河镇', '108.64257', '28.653002', 33);
INSERT INTO `street` VALUES (29584, '500242114', '500242', '板溪镇', '板溪镇', '108.767204', '28.839828', 2);
INSERT INTO `street` VALUES (29585, '500242200', '500242', '涂市乡', '涂市乡', '108.875526', '28.911144', 30);
INSERT INTO `street` VALUES (29586, '500242202', '500242', '铜鼓乡', '铜鼓乡', '108.691788', '28.774086', 29);
INSERT INTO `street` VALUES (29587, '500242204', '500242', '可大乡', '可大乡', '109.246635', '29.02636', 13);
INSERT INTO `street` VALUES (29588, '500242205', '500242', '偏柏乡', '偏柏乡', '109.102455', '29.026798', 24);
INSERT INTO `street` VALUES (29589, '500242206', '500242', '五福乡', '五福乡', '109.123039', '29.114941', 32);
INSERT INTO `street` VALUES (29590, '500242207', '500242', '木叶乡', '木叶乡', '108.996422', '29.250713', 21);
INSERT INTO `street` VALUES (29591, '500242208', '500242', '毛坝乡', '毛坝乡', '108.908638', '29.099026', 18);
INSERT INTO `street` VALUES (29592, '500242209', '500242', '花田乡', '花田乡', '108.714371', '28.950167', 12);
INSERT INTO `street` VALUES (29593, '500242210', '500242', '后坪乡', '后坪乡', '108.407021', '28.689047', 11);
INSERT INTO `street` VALUES (29594, '500242211', '500242', '天馆乡', '天馆乡', '108.468903', '28.848114', 28);
INSERT INTO `street` VALUES (29595, '500242212', '500242', '宜居乡', '宜居乡', '108.595245', '28.873236', 35);
INSERT INTO `street` VALUES (29596, '500242213', '500242', '万木乡', '万木乡', '108.504875', '28.656639', 31);
INSERT INTO `street` VALUES (29597, '500242214', '500242', '两罾乡', '两罾乡', '108.399437', '28.877329', 15);
INSERT INTO `street` VALUES (29598, '500242215', '500242', '板桥乡', '板桥乡', '108.728027', '28.696362', 1);
INSERT INTO `street` VALUES (29599, '500242216', '500242', '官清乡', '官清乡', '108.694473', '28.61248', 9);
INSERT INTO `street` VALUES (29600, '500242217', '500242', '南腰界乡', '南腰界乡', '108.652565', '28.393147', 23);
INSERT INTO `street` VALUES (29601, '500242218', '500242', '车田乡', '车田乡', '109.048431', '29.136536', 4);
INSERT INTO `street` VALUES (29602, '500242219', '500242', '腴地乡', '腴地乡', '108.929482', '29.00386', 38);
INSERT INTO `street` VALUES (29603, '500242220', '500242', '清泉乡', '清泉乡', '108.394707', '28.7925', 25);
INSERT INTO `street` VALUES (29604, '500242221', '500242', '庙溪乡', '庙溪乡', '108.474861', '29.053654', 20);
INSERT INTO `street` VALUES (29605, '500242222', '500242', '浪坪乡', '浪坪乡', '108.54882', '29.075422', 14);
INSERT INTO `street` VALUES (29606, '500242223', '500242', '双泉乡', '双泉乡', '108.657127', '29.015667', 26);
INSERT INTO `street` VALUES (29607, '500242224', '500242', '楠木乡', '楠木乡', '108.771828', '28.602167', 22);
INSERT INTO `street` VALUES (29608, '500243001', '500243', '汉葭街道', '汉葭街道', '108.16655', '29.293856', 7);
INSERT INTO `street` VALUES (29609, '500243002', '500243', '绍庆街道', '绍庆街道', '108.16655', '29.293856', 26);
INSERT INTO `street` VALUES (29610, '500243003', '500243', '靛水街道', '靛水街道', '108.16655', '29.293856', 4);
INSERT INTO `street` VALUES (29611, '500243101', '500243', '保家镇', '保家镇', '108.323441', '29.435318', 2);
INSERT INTO `street` VALUES (29612, '500243102', '500243', '郁山镇', '郁山镇', '108.430511', '29.527559', 36);
INSERT INTO `street` VALUES (29613, '500243103', '500243', '高谷镇', '高谷镇', '108.077827', '29.390322', 6);
INSERT INTO `street` VALUES (29614, '500243104', '500243', '桑柘镇', '桑柘镇', '108.407089', '29.27261', 23);
INSERT INTO `street` VALUES (29615, '500243105', '500243', '鹿角镇', '鹿角镇', '108.292442', '29.129055', 15);
INSERT INTO `street` VALUES (29616, '500243106', '500243', '黄家镇', '黄家镇', '108.063881', '29.120739', 8);
INSERT INTO `street` VALUES (29617, '500243107', '500243', '普子镇', '普子镇', '108.336494', '29.62796', 20);
INSERT INTO `street` VALUES (29618, '500243108', '500243', '龙射镇', '龙射镇', '108.220764', '29.526257', 12);
INSERT INTO `street` VALUES (29619, '500243109', '500243', '连湖镇', '连湖镇', '108.445412', '29.692207', 11);
INSERT INTO `street` VALUES (29620, '500243110', '500243', '万足镇', '万足镇', '108.212242', '29.180759', 32);
INSERT INTO `street` VALUES (29621, '500243111', '500243', '平安镇', '平安镇', '108.16655', '29.293856', 19);
INSERT INTO `street` VALUES (29622, '500243112', '500243', '长生镇', '长生镇', '108.16655', '29.293856', 37);
INSERT INTO `street` VALUES (29623, '500243113', '500243', '新田镇', '新田镇', '108.16655', '29.293856', 34);
INSERT INTO `street` VALUES (29624, '500243114', '500243', '鞍子镇', '鞍子镇', '108.16655', '29.293856', 1);
INSERT INTO `street` VALUES (29625, '500243201', '500243', '岩东乡', '岩东乡', '108.245819', '29.280153', 35);
INSERT INTO `street` VALUES (29626, '500243202', '500243', '鹿鸣乡', '鹿鸣乡', '108.091293', '29.444311', 16);
INSERT INTO `street` VALUES (29627, '500243204', '500243', '棣棠乡', '棣棠乡', '108.225731', '29.600071', 5);
INSERT INTO `street` VALUES (29628, '500243205', '500243', '太原乡', '太原乡', '108.284584', '29.69429', 30);
INSERT INTO `street` VALUES (29629, '500243206', '500243', '三义乡', '三义乡', '108.389153', '29.722281', 24);
INSERT INTO `street` VALUES (29630, '500243207', '500243', '联合乡', '联合乡', '108.435616', '29.5898', 10);
INSERT INTO `street` VALUES (29631, '500243208', '500243', '石柳乡', '石柳乡', '108.465202', '29.605043', 27);
INSERT INTO `street` VALUES (29632, '500243209', '500243', '龙溪乡', '龙溪乡', '108.520012', '29.466345', 14);
INSERT INTO `street` VALUES (29633, '500243210', '500243', '走马乡', '走马乡', '108.465805', '29.418943', 39);
INSERT INTO `street` VALUES (29634, '500243211', '500243', '芦塘乡', '芦塘乡', '108.340614', '29.518036', 17);
INSERT INTO `street` VALUES (29635, '500243213', '500243', '乔梓乡', '乔梓乡', '108.399841', '29.407322', 21);
INSERT INTO `street` VALUES (29636, '500243216', '500243', '梅子垭乡', '梅子垭乡', '108.524391', '29.155252', 18);
INSERT INTO `street` VALUES (29637, '500243217', '500243', '诸佛乡', '诸佛乡', '108.454323', '29.235085', 38);
INSERT INTO `street` VALUES (29638, '500243218', '500243', '小厂乡', '小厂乡', '108.517357', '29.343412', 33);
INSERT INTO `street` VALUES (29639, '500243219', '500243', '桐楼乡', '桐楼乡', '108.559341', '29.283197', 31);
INSERT INTO `street` VALUES (29640, '500243222', '500243', '善感乡', '善感乡', '108.354965', '29.08157', 25);
INSERT INTO `street` VALUES (29641, '500243223', '500243', '双龙乡', '双龙乡', '108.267906', '29.094542', 29);
INSERT INTO `street` VALUES (29642, '500243224', '500243', '石盘乡', '石盘乡', '108.213455', '29.133533', 28);
INSERT INTO `street` VALUES (29643, '500243225', '500243', '大垭乡', '大垭乡', '107.890274', '29.018114', 3);
INSERT INTO `street` VALUES (29644, '500243226', '500243', '润溪乡', '润溪乡', '107.925873', '29.072121', 22);
INSERT INTO `street` VALUES (29645, '500243227', '500243', '朗溪乡', '朗溪乡', '108.146294', '29.070196', 9);
INSERT INTO `street` VALUES (29646, '500243228', '500243', '龙塘乡', '龙塘乡', '107.995605', '29.062458', 13);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
